FA模块数据流

 

--资产主表：
SELECT * FROM FA_ADDITIONS_V FA WHERE FA.ASSET_ID = 10014;

--资产账簿
SELECT *
  FROM FA_BOOKS_V
 WHERE DATE_INEFFECTIVE IS NULL
   AND (BOOK_TYPE_CODE = 'MEWBG FA NEW-B')
   AND (ASSET_ID = 10014);

--资产来源行
SELECT *
  FROM FA_INVOICE_DETAILS_V
 WHERE ASSET_ID = 10014
 ORDER BY INVOICE_NUMBER
         ,AP_DISTRIBUTION_LINE_NUMBER;

--资产分配
SELECT *
  FROM FA_DISTRIBUTION_HISTORY
 WHERE BOOK_TYPE_CODE = 'MEWBG FA NEW-B'
   AND ASSET_ID = 10014;

--资产财务信息主表
SELECT * FROM FA_BOOKS_BOOK_CONTROLS_V WHERE ASSET_ID = 10014;

--资产折旧信息
SELECT *
  FROM FA_FINANCIAL_INQUIRY_DEPRN_V
 WHERE (BOOK_TYPE_CODE = 'MEWBG FA NEW-B')
   AND (ASSET_ID = 10014)
 ORDER BY PERIOD_COUNTER DESC;

--资产成本历史记录
SELECT *
  FROM FA_FINANCIAL_INQUIRY_COST_V
 WHERE (BOOK_TYPE_CODE = 'MEWBG FA NEW-B')
   AND (ASSET_ID = 10014)
 ORDER BY TRANSACTION_HEADER_ID_IN DESC;
--FA传到总账的会计分录

SELECT *
  FROM GL_JE_HEADERS_V GJH
      ,GL_JE_LINES_V   GJL
 WHERE GJH.JE_HEADER_ID = GJL.JE_HEADER_ID
   AND GJH.ACTUAL_FLAG = 'A'
   AND GJH.PERIOD_NAME = 'Sep-11'
   AND GJH.SET_OF_BOOKS_ID = 2

--FA事务处理分录

SELECT * FROM XLA_AEL_SL_V ;