APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 82: FROM ra_customer_trx_all ract,

78: SELECT ract.legal_entity_id,
79: cd.org_id
80: INTO l_event_source_info.legal_entity_id ,
81: l_org_id
82: FROM ra_customer_trx_all ract,
83: jl_br_ar_collection_docs cd
84: WHERE ract.customer_trx_id = cd.customer_trx_id
85: AND ract.org_id = cd.org_id
86: AND cd.document_id = p_document_id;

Line 145: ra_customer_trx_all ract,

141: to_char(cd.document_id)||':'||bo.description)
142: INTO
143: l_event_source_info.transaction_number
144: FROM jl_br_ar_collection_docs cd,
145: ra_customer_trx_all ract,
146: jl_br_ar_bank_occurrences bo,
147: jl_br_ar_occurrence_docs_all oc
148: WHERE ract.customer_trx_id = cd.customer_trx_id
149: AND ract.org_id = cd.org_id

Line 193: ra_customer_trx_all ract,

189: to_char(cd.document_id)||':'||bo.description)
190: INTO
191: l_event_source_info.transaction_number
192: FROM jl_br_ar_collection_docs cd,
193: ra_customer_trx_all ract,
194: jl_br_ar_bank_occurrences bo,
195: jl_br_ar_occurrence_docs_all oc
196: WHERE ract.customer_trx_id = cd.customer_trx_id
197: AND ract.org_id = cd.org_id

Line 580: from ra_customer_trx_all ct,

576: l_trx_number,
577: l_name,
578: l_bordero_id,
579: l_payment_schedule_id
580: from ra_customer_trx_all ct,
581: ar_payment_schedules_all ps,
582: jl_br_ar_select_controls sc,
583: jl_br_ar_borderos bo,
584: jl_br_ar_collection_docs cd

Line 1185: ra_customer_trx_all ract,

1181: csc.select_account_id, oc.flag_post_gl, oc.gl_date, cd.org_id,
1182: cd.payment_schedule_id
1183: from jl_br_ar_collection_docs_all cd,
1184: jl_br_ar_occurrence_docs_all oc,
1185: ra_customer_trx_all ract,
1186: jl_br_ar_bank_occurrences bo,
1187: jl_br_ar_select_accounts_all csc,
1188: jl_br_ar_borderos_all b
1189: where oc.document_id between l_start_id and l_end_id

Line 1840: ra_customer_trx_all ract,

1836: oc.ROWID RID
1837: FROM
1838: jl_br_ar_occurrence_docs_all oc,
1839: jl_br_ar_collection_docs_all cd,
1840: ra_customer_trx_all ract,
1841: jl_br_ar_bank_occurrences bo,
1842: jl_br_ar_select_accounts_all csc,
1843: jl_br_ar_borderos_all b,
1844: ar_system_parameters_all sys,

Line 2794: FROM ra_customer_trx_all trx,

2790: ,'Y' -- SELECT_FLAG
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

Line 3158: ra_customer_trx_all ct,

3154: from
3155: jl_br_ar_occurrence_docs_all od,
3156: jl_br_ar_mc_occ_docs mcod,
3157: jl_br_ar_collection_docs_all cd,
3158: ra_customer_trx_all ct,
3159: gl_ledgers lgr,
3160: gl_date_period_map map,
3161: gl_period_statuses gps,
3162: jl_br_ar_distributns_all dist,

Line 3511: ra_customer_trx_all ct,

3507: from
3508: jl_br_ar_occurrence_docs_all od,
3509: jl_br_ar_mc_occ_docs mcod,
3510: jl_br_ar_collection_docs_all cd,
3511: ra_customer_trx_all ct,
3512: gl_ledgers lgr,
3513: gl_date_period_map map,
3514: gl_period_statuses gps,
3515: jl_br_ar_distributns_all dist,