EBS: FA-资产-子分类帐日记账分录行

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
SELECT XAH.REQUEST_ID AS "请求编号",
       XAH.JE_CATEGORY_NAME  AS "事件类型",
       XAH.DESCRIPTION AS XAH_DESCRIPTION,
       FA.ASSET_NUMBER AS "资产编号",
       XAL.AE_LINE_NUM AS "行号",
       FA_RX_FLEX_PKG.get_value(
        p_application_id => 101,-- in number,
        p_id_flex_code =>'GL#', -- in varchar2,
        p_id_flex_num  =>50368, -- in number default NULL,  -- CHART_OF_ACCOUNT_ID
        p_qualifier => 'ALL', --in varchar2,
        p_ccid =>XAL.CODE_COMBINATION_ID --in number  -- code_Combination_id   
       AS "帐户",
       xla_oa_functions_pkg.get_ccid_description(p_coa_id =>50368,  -- IN NUMBER, CHART_OF_ACCOUNT_ID
               p_ccid => XAL.CODE_COMBINATION_ID  -- IN NUMBER, CODE_COMBINZATION_ID
         AS "帐户描述",
       XAL.ENTERED_DR AS "借项",
       XAL.ENTERED_CR AS "贷项",
       XAL.DESCRIPTION AS "说明",
       XAH.*
  FROM XLA.XLA_AE_HEADERS  XAH,
       XLA.XLA_AE_LINES XAL,
       XLA.XLA_TRANSACTION_ENTITIES XTE,
       FA_TRANSACTION_HEADERS FTH,  --
       FA_ADDITIONS_V FA  -- 资产增加
WHERE XAH.APPLICATION_ID = 140
AND XAH.CREATION_DATE>= SYSDATE -200
AND XAL.AE_HEADER_ID = XAH.AE_HEADER_ID
--AND XAH.JE_CATEGORY_NAME = 'Adjustment'
AND XAH.ENTITY_ID = XTE.ENTITY_ID
AND XTE.SOURCE_ID_INT_1 = FTH.TRANSACTION_HEADER_ID
AND XTE.SOURCE_ID_CHAR_1 = FTH.BOOK_TYPE_CODE
AND FTH.ASSET_ID = FA.ASSET_ID
AND FA.ASSET_NUMBER = '122397'  -- 资产编号 

  

posted @   samrv  阅读(149)  评论(0编辑  收藏  举报
相关博文:
阅读排行:
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
点击右上角即可分享
微信分享提示