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_PAY_INVOICES_DISB_PVT dependencies on AR_DISTRIBUTIONS_ALL

Line 69: -- Modified cursor to query from ar_distributions_all to fetch receipt application

65: AND customer_trx_line_id = cp_customer_trx_line_id;
66: */
67:
68: --Bug# 12385206
69: -- Modified cursor to query from ar_distributions_all to fetch receipt application
70: -- amounts where receipt has been applied either in OKL or in AR
71: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER,cp_customer_trx_line_id NUMBER) IS
72: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) receipt_amount
73: FROM ar_receivable_applications_all raa,

Line 74: ar_distributions_all ad

70: -- amounts where receipt has been applied either in OKL or in AR
71: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER,cp_customer_trx_line_id NUMBER) IS
72: SELECT SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) receipt_amount
73: FROM ar_receivable_applications_all raa,
74: ar_distributions_all ad
75: WHERE raa.applied_customer_trx_id = cp_customer_trx_id
76: AND raa.application_type = 'CASH'
77: AND raa.status = 'APP'
78: AND raa.display = 'Y'