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 AP_PAYMENT_HIST_DISTS

Line 27: -- ap_payment_hist_dists ap_prepay_app_dists

23: -- | | |
24: -- | +---------------------------------------------+ |
25: -- | | |
26: -- /|\ /|\ /|\
27: -- ap_payment_hist_dists ap_prepay_app_dists
28: --
29: --
30: -- Each record in the AP_INVOICE_PAYMENTS_ALL table relates a portion of a
31: -- payment to an invoice.

Line 36: -- Each record in the AP_PAYMENT_HIST_DISTS table relates a payment

32: --
33: -- Each record in the AP_INVOICE_DISTRIBUTIONS_ALL table relates a portion of
34: -- the cost of an invoice to an accounting cost object.
35: --
36: -- Each record in the AP_PAYMENT_HIST_DISTS table relates a payment
37: -- distribution to a distribution.
38: --
39: -- Each record in the AP_PREPAY_APP_DISTS table relates a prepayment
40: -- distribution to a distribution.

Line 2393: FROM AP_Payment_Hist_Dists APHD,

2389: /* Getting the sum of dist amount for the given distribution */
2390: -- 9803363 , added code to get dist id and awt calculated on it
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

Line 2398: from ap_payment_hist_dists aphd_awt,

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
2400: where 1=1
2401: and aphd_item.invoice_distribution_id = p_invoice_distribution_id
2402: and aphd_item.pay_dist_lookup_code <> 'AWT'

Line 2399: ap_payment_hist_dists aphd_item

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
2400: where 1=1
2401: and aphd_item.invoice_distribution_id = p_invoice_distribution_id
2402: and aphd_item.pay_dist_lookup_code <> 'AWT'
2403: and aphd_awt.awt_related_id = aphd_item.invoice_distribution_id

Line 2417: FROM AP_Payment_Hist_Dists APHD,

2413: /* Getting the sum of dist amount for the given distribution */
2414: -- 9803363 , added code to get dist id and awt calculated on it
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

Line 2422: from ap_payment_hist_dists aphd_awt,

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
2424: where 1=1
2425: and aphd_item.invoice_distribution_id = p_invoice_distribution_id
2426: and aphd_item.pay_dist_lookup_code <> 'AWT'

Line 2423: ap_payment_hist_dists aphd_item

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
2424: where 1=1
2425: and aphd_item.invoice_distribution_id = p_invoice_distribution_id
2426: and aphd_item.pay_dist_lookup_code <> 'AWT'
2427: and aphd_awt.awt_related_id = aphd_item.invoice_distribution_id

Line 2440: FROM AP_Payment_Hist_Dists APHD,

2436: /* Getting the sum of dist amount for the given distribution */
2437: -- 9803363 , added code to get dist id and awt calculated on it
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

Line 2445: from ap_payment_hist_dists aphd_awt,

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
2447: where 1=1
2448: and aphd_item.invoice_distribution_id = p_invoice_distribution_id
2449: and aphd_item.pay_dist_lookup_code <> 'AWT'

Line 2446: ap_payment_hist_dists aphd_item

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
2447: where 1=1
2448: and aphd_item.invoice_distribution_id = p_invoice_distribution_id
2449: and aphd_item.pay_dist_lookup_code <> 'AWT'
2450: and aphd_awt.awt_related_id = aphd_item.invoice_distribution_id