Product: | XLA - Subledger Accounting |
---|---|
Description: | This view is used in assigning the completion based sequence numbers to the journal entries generated during a run of accounting program. |
Implementation/DBA Data: |
![]() |
SELECT AEH.AE_HEADER_ID
, AEH.LEDGER_ID
, AEH.BALANCE_TYPE_CODE
, XSL.JE_SOURCE_NAME
, AEH.JE_CATEGORY_NAME
, AEH.DOC_CATEGORY_CODE
, AEH.EVENT_TYPE_CODE
, AEH.ACCOUNTING_ENTRY_TYPE_CODE
, AEH.ACCOUNTING_DATE
, AEH.COMPLETED_DATE
, AEH.COMPLETION_ACCT_SEQ_ASSIGN_ID
, AEH.COMPLETION_ACCT_SEQ_VERSION_ID
, AEH.COMPLETION_ACCT_SEQ_VALUE
, AEH.APPLICATION_ID
FROM XLA_AE_HEADERS AEH
, XLA_EVENTS_GT XEG
, XLA_SUBLEDGERS XSL
WHERE AEH.APPLICATION_ID = XEG.APPLICATION_ID
AND AEH.EVENT_ID = XEG.EVENT_ID
AND XSL.APPLICATION_ID = XEG.APPLICATION_ID
AND NVL(AEH.ZERO_AMOUNT_FLAG
, 'N') = 'N'