DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AR_CASH_RECEIPTS_ALL

Line 3544: ,ar_cash_receipts_all cra

3540: ,okl_cnsld_ar_lines_b lln
3541: ,okl_cnsld_ar_hdrs_b cnr
3542: ,ar_payment_schedules_all aps
3543: ,ar_receivable_applications_all raa
3544: ,ar_cash_receipts_all cra
3545: ,okl_strm_type_v sty
3546: WHERE lsm.receivables_invoice_id > 0
3547: AND lsm.lln_id = lln.id
3548: AND lln.cnr_id = cnr.id

Line 3580: ar_cash_receipts_all cra,

3576: okl_cnsld_ar_lines_b lln,
3577: okl_cnsld_ar_hdrs_b cnr,
3578: ar_payment_schedules_all aps,
3579: ar_receivable_applications_all raa,
3580: ar_cash_receipts_all cra,
3581: okl_strm_type_v sty_ln_pmt,
3582: okl_strm_elements_v sel_ln_pmt
3583: WHERE lsm.receivables_invoice_id > 0
3584: AND lsm.lln_id = lln.id

Line 3917: ar_cash_receipts_all cra,

3913: okl_cnsld_ar_lines_b lln,
3914: okl_cnsld_ar_hdrs_b cnr,
3915: ar_payment_schedules_all aps,
3916: ar_receivable_applications_all raa,
3917: ar_cash_receipts_all cra,
3918: okl_strm_type_v sty
3919: WHERE lsm.receivables_invoice_id > 0
3920: AND lsm.lln_id = lln.id
3921: AND lln.cnr_id = cnr.id

Line 3968: ar_cash_receipts_all cra,

3964: okl_cnsld_ar_lines_b lln,
3965: okl_cnsld_ar_hdrs_b cnr,
3966: ar_payment_schedules_all aps,
3967: ar_receivable_applications_all raa,
3968: ar_cash_receipts_all cra,
3969: okl_strm_type_v sty
3970: WHERE lsm.receivables_invoice_id > 0
3971: AND lsm.lln_id = lln.id
3972: AND lln.cnr_id = cnr.id

Line 4284: ar_cash_receipts_all cra,

4280: okl_txl_ar_inv_lns_b til,
4281: okl_trx_ar_invoices_b tai,
4282: ar_payment_schedules_all aps,
4283: ar_receivable_applications_all raa,
4284: ar_cash_receipts_all cra,
4285: okl_strm_type_b sty,
4286: ar_distributions_all ad
4287: WHERE tai.trx_status_code = 'PROCESSED'
4288: AND tai.khr_id = p_contract_id

Line 4315: ar_cash_receipts_all cra,

4311: okl_txl_ar_inv_lns_b til,
4312: okl_trx_ar_invoices_b tai,
4313: ar_payment_schedules_all aps,
4314: ar_receivable_applications_all raa,
4315: ar_cash_receipts_all cra,
4316: okl_strm_type_b sty
4317: WHERE tai.trx_status_code = 'PROCESSED'
4318: AND tai.khr_id = p_contract_id
4319: AND tld.khr_id = p_contract_id

Line 4891: ar_cash_receipts_all cra,

4887: 'R' txn_type
4888: FROM okl_bpd_tld_ar_lines_v tld,
4889: ar_payment_schedules_all aps,
4890: ar_receivable_applications_all raa,
4891: ar_cash_receipts_all cra,
4892: okl_strm_type_v sty
4893: WHERE tld.trx_status_code = 'PROCESSED'
4894: AND tld.khr_id = NVL(p_contract_id, tld.khr_id)
4895: AND tld.customer_trx_id = aps.customer_trx_id

Line 7843: ,ar_cash_receipts_all cra

7839: ,okl_txl_ar_inv_lns_b til
7840: ,okl_trx_ar_invoices_b tai
7841: ,ar_payment_schedules_all aps
7842: ,ar_receivable_applications_all raa
7843: ,ar_cash_receipts_all cra
7844: ,okl_strm_type_b sty
7845: WHERE tai.trx_status_code = 'PROCESSED'
7846: AND tai.khr_id = cp_khr_id
7847: AND tld.khr_id = cp_khr_id

Line 8136: ,ar_cash_receipts_all cra

8132: ,okl_txl_ar_inv_lns_b til
8133: ,okl_trx_ar_invoices_b tai
8134: ,ar_payment_schedules_all aps
8135: ,ar_receivable_applications_all raa
8136: ,ar_cash_receipts_all cra
8137: ,okl_strm_type_b sty
8138: WHERE tai.trx_status_code = 'PROCESSED'
8139: AND tai.khr_id = cp_khr_id
8140: AND tld.khr_id = cp_khr_id