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' -- 资产编号 |
优质生活从拆开始
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· DeepSeek 开源周回顾「GitHub 热点速览」
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了