AR_CM_BATCHES_H_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name
CM_BATCH_DATE CM_BATCH_ID CM_BATCH_COMMENTS CM_BATCH_NAME LEDGER_ID EVENT_ID

Query

SQL_Statement
SELECT /*+INDEX(he ar_xla_lines_extract_n1) */ bac1.batch_date cm_batch_date ,bac1.batch_id cm_batch_id ,bac1.comments cm_batch_comments ,bac1.name cm_batch_name ,ledger_id ledger_id ,he.event_id event_id FROM ra_batches_all bac1 ,ar_xla_lines_extract he WHERE he.batch_id = bac1.batch_id AND he.level_flag = 'H' AND he.org_id = bac1.org_id