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_ACCTG_PAY_ROUND_PKG dependencies on AP_PAYMENT_HISTORY_ALL

Line 437: AP_Payment_History_All APH,

433: -- 'TAX EXCHANGE RATE VARIANCE', -1*APHD.Invoice_Dist_Base_Amount,
434: APHD.Invoice_Dist_Base_Amount)
435: INTO l_sum_pay_dist_base_amt
436: FROM AP_Payment_Hist_Dists APHD,
437: AP_Payment_History_All APH,
438: AP_Invoice_Payments_All AIP
439: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
440: AND APHD.Pay_Dist_Lookup_Code IN
441: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING'))

Line 460: AP_Payment_History_All APH,

456: -- 'TAX EXCHANGE RATE VARIANCE', -1*APHD.Invoice_Dist_Base_Amount,
457: APHD.Invoice_Dist_Base_Amount)
458: INTO l_sum_pay_dist_base_amt
459: FROM AP_Payment_Hist_Dists APHD,
460: AP_Payment_History_All APH,
461: AP_Invoice_Payments_All AIP
462: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
463: AND APHD.Pay_Dist_Lookup_Code IN
464: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING' ))

Line 482: AP_Payment_History_All APH,

478: -- 'TAX EXCHANGE RATE VARIANCE', -1*APHD.Invoice_Dist_Base_Amount,
479: APHD.Invoice_Dist_Base_Amount)
480: INTO l_sum_pay_dist_base_amt
481: FROM AP_Payment_Hist_Dists APHD,
482: AP_Payment_History_All APH,
483: AP_Invoice_Payments_All AIP
484: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
485: AND APHD.Pay_Dist_Lookup_Code IN
486: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING' ))

Line 833: AP_Payment_History_All APH

829: l_disc_clr_rate_sum_amt,
830: l_err_clr_rate_sum_amt,
831: l_chrg_clr_rate_sum_amt
832: FROM AP_Payment_Hist_Dists APHD,
833: AP_Payment_History_All APH
834: WHERE APH.Related_Event_ID = p_pay_hist_rec.Related_Event_ID
835: AND APHD.Invoice_Payment_ID = p_inv_pay_rec.Invoice_Payment_ID
836: AND APHD.Payment_History_ID = APH.Payment_History_ID
837: AND APHD.Invoice_Distribution_ID IN

Line 854: AP_PAYMENT_HISTORY_ALL APH

850: 'AWT', APHD.Invoice_Dist_Base_Amount,
851: 'DISCOUNT', APHD.Invoice_Dist_Base_Amount, 0))
852: INTO l_pay_sum_amt,l_max_dist_id,l_inv_rate_sum_full_amt
853: FROM AP_PAYMENT_HIST_DISTS APHD,
854: AP_PAYMENT_HISTORY_ALL APH
855: WHERE
856: APHD.PAYMENT_HISTORY_ID =APH.PAYMENT_HISTORY_ID
857: ANd APHD.INVOICE_PAYMENT_ID =p_inv_pay_rec.Invoice_Payment_ID --6614295
858: AND APHD.Invoice_Distribution_ID IN

Line 1348: AP_Payment_History_All APH,

1344: -- Get the paid base amounts for the payment event
1345: SELECT SUM(APHD.Paid_Base_Amount)
1346: INTO l_sum_pay_paid_base_amt
1347: FROM AP_Payment_Hist_Dists APHD,
1348: AP_Payment_History_All APH,
1349: AP_Payment_History_All APH1
1350: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_pay_pmt_history_id
1351: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
1352: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 1349: AP_Payment_History_All APH1

1345: SELECT SUM(APHD.Paid_Base_Amount)
1346: INTO l_sum_pay_paid_base_amt
1347: FROM AP_Payment_Hist_Dists APHD,
1348: AP_Payment_History_All APH,
1349: AP_Payment_History_All APH1
1350: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_pay_pmt_history_id
1351: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
1352: AND APHD.Payment_History_ID = APH.Payment_History_ID
1353: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')

Line 1366: AP_Payment_History_All APH,

1362: SUM(APHD.Matured_Base_Amount)
1363: INTO l_sum_mat_paid_base_amt,
1364: l_sum_mat_mat_base_amt
1365: FROM AP_Payment_Hist_Dists APHD,
1366: AP_Payment_History_All APH,
1367: AP_Payment_History_All APH1
1368: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_mat_pmt_history_id
1369: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
1370: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 1367: AP_Payment_History_All APH1

1363: INTO l_sum_mat_paid_base_amt,
1364: l_sum_mat_mat_base_amt
1365: FROM AP_Payment_Hist_Dists APHD,
1366: AP_Payment_History_All APH,
1367: AP_Payment_History_All APH1
1368: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_mat_pmt_history_id
1369: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
1370: AND APHD.Payment_History_ID = APH.Payment_History_ID
1371: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')

Line 1389: AP_Payment_History_All APH,

1385: SUM(APHD.Matured_Base_Amount)
1386: INTO l_sum_clr_paid_base_amt,
1387: l_sum_clr_mat_base_amt
1388: FROM AP_Payment_Hist_Dists APHD,
1389: AP_Payment_History_All APH,
1390: AP_Payment_History_All APH1
1391: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_clr_pmt_history_id
1392: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
1393: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 1390: AP_Payment_History_All APH1

1386: INTO l_sum_clr_paid_base_amt,
1387: l_sum_clr_mat_base_amt
1388: FROM AP_Payment_Hist_Dists APHD,
1389: AP_Payment_History_All APH,
1390: AP_Payment_History_All APH1
1391: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_clr_pmt_history_id
1392: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
1393: AND APHD.Payment_History_ID = APH.Payment_History_ID
1394: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')

Line 1930: AP_Payment_History_All APH

1926: -- Get the paid base amount for the payment event
1927: SELECT SUM(APHD.Paid_Base_Amount)
1928: INTO l_sum_pay_paid_base_amt
1929: FROM AP_Payment_Hist_Dists APHD,
1930: AP_Payment_History_All APH
1931: WHERE APH.Related_Event_ID = p_pay_hist_rec.Related_Event_ID
1932: AND APHD.Payment_History_ID = APH.Payment_History_ID
1933: AND Invoice_Distribution_ID IN
1934: (SELECT AID.Invoice_Distribution_ID

Line 1945: AP_Payment_History_All APH

1941: -- Get the cleared base amount for the payment clearing event
1942: SELECT SUM(APHD.Cleared_Base_Amount)
1943: INTO l_sum_pay_clrd_base_amt
1944: FROM AP_Payment_Hist_Dists APHD,
1945: AP_Payment_History_All APH
1946: WHERE APH.Related_Event_ID = p_clr_hist_rec.related_event_id
1947: AND APHD.Payment_History_ID = APH.Payment_History_ID
1948: AND Invoice_Distribution_ID IN
1949: (SELECT AID.Invoice_Distribution_ID