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
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
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
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
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
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
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
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
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