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

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 @ 2022-12-01 09:12  samrv  阅读(133)  评论(0编辑  收藏  举报