AR_TRX_BATCH_SOURCE_S_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
BATCH_SOURCE_SEQ_ID BATCH_SOURCE_DESCRIPTION BATCH_SOURCE_GLOBAL_ATTR1 BATCH_SOURCE_GLOBAL_ATTR2 BATCH_SOURCE_GLOBAL_ATTR3 BATCH_SOURCE_GLOBAL_ATTR4 BATCH_SOURCE_GLOBAL_ATTR5 BATCH_SOURCE_GLOBAL_ATTR6 BATCH_SOURCE_GLOBAL_ATTR_CAT BATCH_SOURCE_NAME EVENT_ID LINE_NUMBER LEDGER_ID

Query

SQL_Statement

SELECT /*+ INDEX(l AR_XLA_LINES_EXTRACT_N1) */ bsa1.batch_source_seq_id batch_source_seq_id , bsa1.description batch_source_description , bsa1.global_attribute1 batch_source_global_attr1 , bsa1.global_attribute2 batch_source_global_attr2 , bsa1.global_attribute3 batch_source_global_attr3 , bsa1.global_attribute4 batch_source_global_attr4 , bsa1.global_attribute5 batch_source_global_attr5 , bsa1.global_attribute6 batch_source_global_attr6 , bsa1.global_attribute_category batch_source_global_attr_cat , bsa1.name batch_source_name , l.event_id event_id , l.line_number line_number , l.ledger_id ledger_id FROM ra_batch_sources_all bsa1 , ar_xla_lines_extract l WHERE l.batch_source_seq_id = bsa1.batch_source_seq_id AND ((l.event_class_code IN ('INVOICE','DEBIT_MEMO','DEPOSIT', 'GUARANTEE','CHARGEBACK','ADJUSTMENT','BILL') AND l.level_flag = 'H') OR (l.event_class_code IN ('CREDIT_MEMO','RECEIPT') AND l.level_flag = 'L' AND l.from_to_flag = 'T'))