VIEW: APPS.XLA_ACCT_PROG_SEQ_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'