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.AP_SLA_PROCESSING_PKG dependencies on DUAL

Line 2395: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual

2391: SELECT SUM(APHD.Invoice_Dist_Amount)
2392: INTO l_paid_acctd_amt
2393: FROM AP_Payment_Hist_Dists APHD,
2394: AP_Payment_History_All APH
2395: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual
2396: union
2397: select distinct aphd_awt.invoice_distribution_id
2398: from ap_payment_hist_dists aphd_awt,
2399: ap_payment_hist_dists aphd_item

Line 2419: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual

2415: SELECT SUM(APHD.Invoice_Dist_Amount)
2416: INTO l_paid_acctd_amt
2417: FROM AP_Payment_Hist_Dists APHD,
2418: AP_Payment_History_All APH
2419: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual
2420: union
2421: select distinct aphd_awt.invoice_distribution_id
2422: from ap_payment_hist_dists aphd_awt,
2423: ap_payment_hist_dists aphd_item

Line 2442: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual

2438: SELECT SUM(APHD.Invoice_Dist_Amount)
2439: INTO l_paid_acctd_amt
2440: FROM AP_Payment_Hist_Dists APHD,
2441: AP_Payment_History_All APH
2442: WHERE APHD.Invoice_Distribution_ID in ( select p_invoice_distribution_id from dual
2443: union
2444: select distinct aphd_awt.invoice_distribution_id
2445: from ap_payment_hist_dists aphd_awt,
2446: ap_payment_hist_dists aphd_item

Line 2465: WHERE APAD.Invoice_Distribution_ID in (select p_invoice_distribution_id from dual

2461: SELECT SUM(APAD.Amount)
2462: INTO l_prepaid_acctd_amt
2463: FROM AP_Prepay_App_Dists APAD,
2464: AP_Prepay_History_All APH
2465: WHERE APAD.Invoice_Distribution_ID in (select p_invoice_distribution_id from dual
2466: union
2467: /* awt distributions which are applied on the p_invoice_distribution_id*/
2468: select distinct aphd_awt.invoice_distribution_id
2469: from ap_prepay_app_dists aphd_awt,