DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_EVENTS_GT

Line 2734: SELECT /*+INDEX (gt XLA_EVENTS_GT_U1)*/

2730: ,LEVEL_FLAG
2731: ,PAIRED_CCID
2732: ,EVENT_CLASS_CODE
2733: )
2734: SELECT /*+INDEX (gt XLA_EVENTS_GT_U1)*/
2735: gt.event_id -- EVENT_ID
2736: ,trx.set_of_books_id -- LEDGER_ID
2737: ,trx.set_of_books_id -- SET_OF_BOOKS_ID
2738: ,trx.org_id -- ORG_ID

Line 2758: xla_events_gt gt,

2754: ,'H' -- LEVEL_FLAG
2755: ,ctlgd.code_combination_id -- PAIRED_CCID
2756: ,'INVOICE' -- EVENT_CLASS_CODE
2757: FROM ra_customer_trx_all trx,
2758: xla_events_gt gt,
2759: ra_cust_trx_line_gl_dist_all ctlgd,
2760: jl_br_ar_collection_docs_all cd,
2761: jl_br_ar_coll_occ_docs_h_v jlh
2762: WHERE gt.entity_code = 'JL_BR_AR_COLL_DOC_OCCS'