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 135: ra_customer_trx_all ract,

131: to_char(cd.document_id)||':'||bo.description)
132: INTO
133: l_event_source_info.transaction_number
134: FROM jl_br_ar_collection_docs cd,
135: ra_customer_trx_all ract,
136: jl_br_ar_bank_occurrences bo,
137: jl_br_ar_occurrence_docs_all oc
138: WHERE ract.customer_trx_id = cd.customer_trx_id
139: AND ract.org_id = cd.org_id

Line 182: ra_customer_trx_all ract,

178: to_char(cd.document_id)||':'||bo.description)
179: INTO
180: l_event_source_info.transaction_number
181: FROM jl_br_ar_collection_docs cd,
182: ra_customer_trx_all ract,
183: jl_br_ar_bank_occurrences bo,
184: jl_br_ar_occurrence_docs_all oc
185: WHERE ract.customer_trx_id = cd.customer_trx_id
186: AND ract.org_id = cd.org_id

Line 560: from ra_customer_trx_all ct,

556: l_trx_number,
557: l_name,
558: l_bordero_id,
559: l_payment_schedule_id
560: from ra_customer_trx_all ct,
561: ar_payment_schedules_all ps,
562: jl_br_ar_select_controls sc,
563: jl_br_ar_borderos bo,
564: jl_br_ar_collection_docs cd

Line 1148: ra_customer_trx_all ract,

1144: csc.select_account_id, oc.flag_post_gl, oc.gl_date, cd.org_id,
1145: cd.payment_schedule_id
1146: from jl_br_ar_collection_docs_all cd,
1147: jl_br_ar_occurrence_docs_all oc,
1148: ra_customer_trx_all ract,
1149: jl_br_ar_bank_occurrences bo,
1150: jl_br_ar_select_accounts_all csc,
1151: jl_br_ar_borderos_all b
1152: where oc.document_id between l_start_id and l_end_id

Line 1803: ra_customer_trx_all ract,

1799: oc.ROWID RID
1800: FROM
1801: jl_br_ar_occurrence_docs_all oc,
1802: jl_br_ar_collection_docs_all cd,
1803: ra_customer_trx_all ract,
1804: jl_br_ar_bank_occurrences bo,
1805: jl_br_ar_select_accounts_all csc,
1806: jl_br_ar_borderos_all b,
1807: ar_system_parameters_all sys,

Line 2757: FROM ra_customer_trx_all trx,

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

Line 3120: ra_customer_trx_all ct,

3116: from
3117: jl_br_ar_occurrence_docs_all od,
3118: jl_br_ar_mc_occ_docs mcod,
3119: jl_br_ar_collection_docs_all cd,
3120: ra_customer_trx_all ct,
3121: gl_ledgers lgr,
3122: gl_date_period_map map,
3123: gl_period_statuses gps,
3124: jl_br_ar_distributns_all dist,

Line 3473: ra_customer_trx_all ct,

3469: from
3470: jl_br_ar_occurrence_docs_all od,
3471: jl_br_ar_mc_occ_docs mcod,
3472: jl_br_ar_collection_docs_all cd,
3473: ra_customer_trx_all ct,
3474: gl_ledgers lgr,
3475: gl_date_period_map map,
3476: gl_period_statuses gps,
3477: jl_br_ar_distributns_all dist,