eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 1617: okl_trx_ar_invoices_b tai,

1613: ,SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) principal_pmt_rcpt_amt -- 4884843, 4872370
1614: FROM okl_txd_ar_ln_dtls_b tld,
1615: ra_customer_trx_lines_all ractrl,
1616: okl_txl_ar_inv_lns_b til,
1617: okl_trx_ar_invoices_b tai,
1618: ar_payment_schedules_all aps,
1619: ar_receivable_applications_all raa,
1620: ar_cash_receipts_all cra,
1621: okl_strm_type_b sty,

Line 1650: okl_trx_ar_invoices_b tai,

1646: ,SUM(raa.line_applied) principal_pmt_rcpt_amt -- 4884843, 4872370
1647: FROM okl_txd_ar_ln_dtls_b tld,
1648: ra_customer_trx_lines_all ractrl,
1649: okl_txl_ar_inv_lns_b til,
1650: okl_trx_ar_invoices_b tai,
1651: ar_payment_schedules_all aps,
1652: ar_receivable_applications_all raa,
1653: ar_cash_receipts_all cra,
1654: okl_strm_type_b sty

Line 1708: okl_trx_ar_invoices_b tai,

1704: ,SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) principal_pmt_rcpt_amt
1705: FROM okl_txd_ar_ln_dtls_b tld,
1706: ra_customer_trx_lines_all ractrl,
1707: okl_txl_ar_inv_lns_b til,
1708: okl_trx_ar_invoices_b tai,
1709: ar_payment_schedules_all aps,
1710: ar_receivable_applications_all raa,
1711: ra_customer_trx_all cm,
1712: okl_strm_type_b sty,

Line 1741: okl_trx_ar_invoices_b tai,

1737: ,SUM(raa.line_applied) principal_pmt_rcpt_amt -- 4884843, 4872370
1738: FROM okl_txd_ar_ln_dtls_b tld,
1739: ra_customer_trx_lines_all ractrl,
1740: okl_txl_ar_inv_lns_b til,
1741: okl_trx_ar_invoices_b tai,
1742: ar_payment_schedules_all aps,
1743: ar_receivable_applications_all raa,
1744: ra_customer_trx_all cm,
1745: okl_strm_type_b sty

Line 1775: okl_trx_ar_invoices_b tai,

1771: ,SUM(nvl(ad.amount_dr,0))- SUM(nvl(ad.amount_cr,0)) principal_pmt_rcpt_amt
1772: FROM okl_txd_ar_ln_dtls_b tld,
1773: ra_customer_trx_lines_all ractrl,
1774: okl_txl_ar_inv_lns_b til,
1775: okl_trx_ar_invoices_b tai,
1776: ar_payment_schedules_all aps,
1777: ar_adjustments_all adj,
1778: okl_strm_type_b sty,
1779: ar_distributions_all ad

Line 4532: ,okl_trx_ar_invoices_b tai

4528: 'Y' return_value
4529: FROM okl_txd_ar_ln_dtls_b tld
4530: ,ra_customer_trx_lines_all ractrl
4531: ,okl_txl_ar_inv_lns_b til
4532: ,okl_trx_ar_invoices_b tai
4533: ,ar_payment_schedules_all aps
4534: ,ar_receivable_applications_all raa
4535: ,ar_cash_receipts_all cra
4536: ,okl_strm_type_b sty

Line 4613: ,okl_trx_ar_invoices_b tai

4609: 'Y' return_value
4610: FROM okl_txd_ar_ln_dtls_b tld
4611: ,ra_customer_trx_lines_all ractrl
4612: ,okl_txl_ar_inv_lns_b til
4613: ,okl_trx_ar_invoices_b tai
4614: ,ar_payment_schedules_all aps
4615: ,ar_receivable_applications_all raa
4616: ,ra_customer_trx_all cm
4617: ,okl_strm_type_b sty

Line 4654: ,okl_trx_ar_invoices_b tai

4650: 'Y' return_value
4651: FROM okl_txd_ar_ln_dtls_b tld
4652: ,ra_customer_trx_lines_all ractrl
4653: ,okl_txl_ar_inv_lns_b til
4654: ,okl_trx_ar_invoices_b tai
4655: ,ar_payment_schedules_all aps
4656: ,ar_adjustments_all adj
4657: ,okl_strm_type_b sty
4658: WHERE tai.trx_status_code = 'PROCESSED'

Line 4954: ,okl_trx_ar_invoices_b tai

4950: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table
4951: FROM okl_txd_ar_ln_dtls_b tld
4952: ,ra_customer_trx_lines_all ractrl
4953: ,okl_txl_ar_inv_lns_b til
4954: ,okl_trx_ar_invoices_b tai
4955: ,ar_payment_schedules_all aps
4956: ,ar_receivable_applications_all raa
4957: ,ar_cash_receipts_all cra
4958: ,okl_strm_type_b sty

Line 5038: ,okl_trx_ar_invoices_b tai

5034: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table
5035: FROM okl_txd_ar_ln_dtls_b tld
5036: ,ra_customer_trx_lines_all ractrl
5037: ,okl_txl_ar_inv_lns_b til
5038: ,okl_trx_ar_invoices_b tai
5039: ,ar_payment_schedules_all aps
5040: ,ar_receivable_applications_all raa
5041: ,ra_customer_trx_all cm
5042: ,okl_strm_type_b sty

Line 5079: ,okl_trx_ar_invoices_b tai

5075: , 'AR_ADJUSTMENTS_ALL' source_table
5076: FROM okl_txd_ar_ln_dtls_b tld
5077: ,ra_customer_trx_lines_all ractrl
5078: ,okl_txl_ar_inv_lns_b til
5079: ,okl_trx_ar_invoices_b tai
5080: ,ar_payment_schedules_all aps
5081: ,ar_adjustments_all adj
5082: ,okl_strm_type_b sty
5083: WHERE tai.trx_status_code = 'PROCESSED'