DBA Data[Home] [Help]

APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_BR_AR_COLLECTION_DOCS_ALL

Line 1183: from jl_br_ar_collection_docs_all cd,

1179: bo.std_occurrence_code, b.bordero_type, bo.bank_occurrence_type,
1180: cd.document_id, oc.bank_party_id, oc.bordero_id, ract.customer_trx_id,
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,

Line 1839: jl_br_ar_collection_docs_all cd,

1835: ract.trx_number TRX_NUMBER ,
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,

Line 2797: jl_br_ar_collection_docs_all cd,

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'
2800: AND gt.application_id = l_application_id
2801: AND jlh.jlbr_document_id = gt.source_id_int_1

Line 3157: jl_br_ar_collection_docs_all cd,

3153: --
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,

Line 3510: jl_br_ar_collection_docs_all cd,

3506: --
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,