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

Line 341: AP_Payment_History_All APH

337:
338: SELECT SUM(APHD.Amount)
339: INTO l_pay_sum
340: FROM AP_Payment_Hist_Dists APHD,
341: AP_Payment_History_All APH
342: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
343: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
344: AND APH.Related_Event_ID = P_Related_Event_ID
345: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 381: AP_Payment_History_All APH

377:
378: SELECT SUM(APHD.Invoice_Dist_Amount)
379: INTO l_inv_dist_sum
380: FROM AP_Payment_Hist_Dists APHD,
381: AP_Payment_History_All APH
382: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
383: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
384: AND APH.Related_Event_ID = P_Related_Event_ID
385: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 421: AP_Payment_History_All APH

417:
418: SELECT SUM(APHD.Bank_Curr_Amount)
419: INTO l_bank_curr_sum
420: FROM AP_Payment_Hist_Dists APHD,
421: AP_Payment_History_All APH
422: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
423: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
424: AND APH.Related_Event_ID = P_Related_Event_ID
425: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 532: AP_Payment_History_All APH

528:
529: SELECT SUM(APHD.Amount)
530: INTO l_discount_sum
531: FROM AP_Payment_Hist_Dists APHD,
532: AP_Payment_History_All APH
533: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
534: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
535: AND APH.Related_Event_ID = P_Related_Event_ID
536: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 571: AP_Payment_History_All APH

567:
568: SELECT SUM(APHD.Invoice_Dist_Amount)
569: INTO l_discount_sum
570: FROM AP_Payment_Hist_Dists APHD,
571: AP_Payment_History_All APH
572: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
573: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
574: AND APH.Related_Event_ID = P_Related_Event_ID
575: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 611: AP_Payment_History_All APH

607:
608: SELECT SUM(APHD.Bank_Curr_Amount)
609: INTO l_discount_sum
610: FROM AP_Payment_Hist_Dists APHD,
611: AP_Payment_History_All APH
612: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
613: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
614: AND APH.Related_Event_ID = P_Related_Event_ID
615: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 660: AP_Payment_History_All APH

656: INTO l_pay_sum,
657: l_inv_dist_sum,
658: l_bank_curr_sum
659: FROM AP_Payment_Hist_Dists APHD,
660: AP_Payment_History_All APH
661: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
662: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT')
663: AND NVL(APH.Posted_Flag, 'N') = 'Y'
664: AND APH.Payment_History_ID = APHD.Payment_History_ID

Line 678: AP_Payment_History_All APH

674: INTO l_pay_sum,
675: l_inv_dist_sum,
676: l_bank_curr_sum
677: FROM AP_Payment_Hist_Dists APHD,
678: AP_Payment_History_All APH
679: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
680: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT')
681: AND NVL(APH.Posted_Flag, 'N') = 'Y'
682: AND APH.Payment_History_ID = APHD.Payment_History_ID

Line 695: AP_Payment_History_All APH

691: INTO l_pay_sum,
692: l_inv_dist_sum,
693: l_bank_curr_sum
694: FROM AP_Payment_Hist_Dists APHD,
695: AP_Payment_History_All APH
696: WHERE APHD.Invoice_Distribution_ID = p_invoice_distribution_id
697: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT')
698: AND NVL(APH.Posted_Flag, 'N') = 'Y'
699: AND APH.Payment_History_ID = APHD.Payment_History_ID

Line 828: AP_Payment_History_All APH

824: APHD.Amount)
825: INTO l_paid_acctd_amt
826: FROM AP_Payment_Hist_Dists APHD,
827: AP_Invoice_Distributions_All AID,
828: AP_Payment_History_All APH
829: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
830: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
831: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT')
832: AND APH.Posted_Flag = 'Y'

Line 854: AP_Payment_History_All APH

850: APHD.Amount)
851: INTO l_paid_acctd_amt
852: FROM AP_Payment_Hist_Dists APHD,
853: AP_Invoice_Distributions_All AID,
854: AP_Payment_History_All APH
855: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
856: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
857: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT')
858: AND APH.Posted_Flag = 'Y'

Line 880: AP_Payment_History_All APH

876: APHD.Amount)
877: INTO l_paid_acctd_amt
878: FROM AP_Payment_Hist_Dists APHD,
879: AP_Invoice_Distributions_All AID,
880: AP_Payment_History_All APH
881: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
882: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID
883: AND APHD.Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT')
884: AND APH.Posted_Flag = 'Y'