DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 4281: okl_trx_ar_invoices_b tai,

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,
4285: okl_strm_type_b sty,

Line 4312: okl_trx_ar_invoices_b tai,

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,
4316: okl_strm_type_b sty

Line 7840: ,okl_trx_ar_invoices_b tai

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
7844: ,okl_strm_type_b sty

Line 8133: ,okl_trx_ar_invoices_b tai

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
8137: ,okl_strm_type_b sty