DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on XLA_EVENTS_GT

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

2767: ,LEVEL_FLAG
2768: ,PAIRED_CCID
2769: ,EVENT_CLASS_CODE
2770: )
2771: SELECT /*+INDEX (gt XLA_EVENTS_GT_U1)*/
2772: gt.event_id -- EVENT_ID
2773: ,trx.set_of_books_id -- LEDGER_ID
2774: ,trx.set_of_books_id -- SET_OF_BOOKS_ID
2775: ,trx.org_id -- ORG_ID

Line 2795: xla_events_gt gt,

2791: ,'H' -- LEVEL_FLAG
2792: ,ctlgd.code_combination_id -- PAIRED_CCID
2793: ,'INVOICE' -- EVENT_CLASS_CODE
2794: FROM ra_customer_trx_all trx,
2795: xla_events_gt gt,
2796: ra_cust_trx_line_gl_dist_all ctlgd,
2797: jl_br_ar_collection_docs_all cd,
2798: jl_br_ar_coll_occ_docs_h_v jlh
2799: WHERE gt.entity_code = 'JL_BR_AR_COLL_DOC_OCCS'