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_TXD_AR_LN_DTLS_B

Line 1614: FROM okl_txd_ar_ln_dtls_b tld,

1610: p_start_date DATE,
1611: p_due_date DATE) IS
1612: SELECT cra.receipt_date receipt_date
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,

Line 1647: FROM okl_txd_ar_ln_dtls_b tld,

1643: GROUP BY cra.receipt_date
1644: UNION ALL
1645: SELECT cra.receipt_date receipt_date
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,

Line 1705: FROM okl_txd_ar_ln_dtls_b tld,

1701: GROUP BY sel.stream_element_date
1702: UNION ALL
1703: SELECT cm.trx_date receipt_date
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,

Line 1738: FROM okl_txd_ar_ln_dtls_b tld,

1734: GROUP BY cm.trx_date
1735: UNION ALL
1736: SELECT cm.trx_date receipt_date
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,

Line 1772: FROM okl_txd_ar_ln_dtls_b tld,

1768: GROUP BY cm.trx_date
1769: UNION ALL
1770: SELECT adj.apply_date receipt_date
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,

Line 4529: FROM okl_txd_ar_ln_dtls_b tld

4525: -- invoices have lines from multiple contracts
4526: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4527: SELECT /*+ leading(tai, til, tld, sty, ractrl, aps) */
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

Line 4610: FROM okl_txd_ar_ln_dtls_b tld

4606: -- Actual Principal Balance
4607: CURSOR l_credit_memo_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4608: SELECT /*+ leading(tai, til, tld, sty, ractrl, aps) */
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

Line 4651: FROM okl_txd_ar_ln_dtls_b tld

4647: -- Actual Principal Balance
4648: CURSOR l_adjustment_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
4649: SELECT /*+ leading(tai, til, tld, sty, ractrl, aps) */
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

Line 4951: FROM okl_txd_ar_ln_dtls_b tld

4947: -- a contract
4948: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
4949: SELECT DISTINCT raa.receivable_application_id source_id
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

Line 5035: FROM okl_txd_ar_ln_dtls_b tld

5031: -- Actual Principal Balance
5032: CURSOR l_credit_memo_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
5033: SELECT DISTINCT raa.receivable_application_id source_id
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

Line 5076: FROM okl_txd_ar_ln_dtls_b tld

5072: -- Actual Principal Balance
5073: CURSOR l_adjustment_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
5074: SELECT DISTINCT adj.adjustment_id source_id
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