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' -- 资产编号
标签：分录,分类帐,XLA,XAH,FA,XAL,--,ID From： https://www.cnblogs.com/samrv/p/16940420.html