APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 4280: okl_txl_ar_inv_lns_b til,

4276: SELECT cra.receipt_date receipt_date
4277: ,SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) principal_pmt_rcpt_amt -- 4884843, 4872370
4278: FROM okl_txd_ar_ln_dtls_b tld,
4279: ra_customer_trx_lines_all ractrl,
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,

Line 4311: okl_txl_ar_inv_lns_b til,

4307: SELECT cra.receipt_date receipt_date
4308: ,SUM(raa.line_applied) principal_pmt_rcpt_amt -- 4884843, 4872370
4309: FROM okl_txd_ar_ln_dtls_b tld,
4310: ra_customer_trx_lines_all ractrl,
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,

Line 7839: ,okl_txl_ar_inv_lns_b til

7835: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7836: SELECT 'Y' return_value
7837: FROM okl_txd_ar_ln_dtls_b tld
7838: ,ra_customer_trx_lines_all ractrl
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

Line 8132: ,okl_txl_ar_inv_lns_b til

8128: SELECT DISTINCT raa.receivable_application_id source_id
8129: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table
8130: FROM okl_txd_ar_ln_dtls_b tld
8131: ,ra_customer_trx_lines_all ractrl
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