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'  -- 资产编号