XLA_ACCT_PROG_SEQ_V

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
AE_HEADER_ID LEDGER_ID BALANCE_TYPE_CODE JE_SOURCE_NAME JE_CATEGORY_NAME DOC_CATEGORY_CODE ACCOUNTING_EVENT_TYPE_CODE ACCOUNTING_ENTRY_TYPE_CODE GL_DATE COMPLETION_DATE COMPLETION_ACCT_SEQ_ASSIGN_ID COMPLETION_ACCT_SEQ_VERSION_ID COMPLETION_ACCT_SEQ_VALUE APPLICATION_ID LEGAL_ENTITY_ID

Query

SQL_Statement

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 accounting_event_type_code ,aeh.accounting_entry_type_code ,aeh.accounting_date gl_date ,aeh.completed_date completion_date ,aeh.completion_acct_seq_assign_id ,aeh.completion_acct_seq_version_id ,aeh.completion_acct_seq_value ,aeh.application_id ,aeh.legal_entity_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 DECODE ( NVL(aeh.zero_amount_flag, 'N'), 'N', 'SEQJRNL', DECODE (NVL(fnd_profile.value('XLA_SHOW_ZERO_AMT_JRNL'), 'N'),'Y', 'SEQJRNL','DONOTSEQ')) = 'SEQJRNL' AND aeh.accounting_entry_status_code = 'F' AND aeh.accounting_batch_id = xeg.accounting_batch_id