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_HIST_DISTS

Line 397: DELETE FROM AP_Payment_Hist_Dists

393: END IF;
394:
395:
396: -- Bug 5098657. Added the where condition for both the delete statements
397: DELETE FROM AP_Payment_Hist_Dists
398: WHERE Accounting_Event_ID IN
399: (SELECT Event_ID
400: FROM XLA_Events_GT
401: WHERE Entity_Code = 'AP_PAYMENTS');

Line 450: FROM AP_Payment_Hist_Dists APHD,

446:
447:
448: SELECT SUM(APHD.Amount)
449: INTO l_pay_sum
450: FROM AP_Payment_Hist_Dists APHD,
451: AP_Payment_History_All APH
452: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
453: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
454: AND APH.Related_Event_ID = P_Related_Event_ID

Line 490: FROM AP_Payment_Hist_Dists APHD,

486:
487:
488: SELECT SUM(APHD.Invoice_Dist_Amount)
489: INTO l_inv_dist_sum
490: FROM AP_Payment_Hist_Dists APHD,
491: AP_Payment_History_All APH
492: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
493: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
494: AND APH.Related_Event_ID = P_Related_Event_ID

Line 530: FROM AP_Payment_Hist_Dists APHD,

526:
527:
528: SELECT SUM(APHD.Bank_Curr_Amount)
529: INTO l_bank_curr_sum
530: FROM AP_Payment_Hist_Dists APHD,
531: AP_Payment_History_All APH
532: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
533: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
534: AND APH.Related_Event_ID = P_Related_Event_ID

Line 641: FROM AP_Payment_Hist_Dists APHD,

637:
638:
639: SELECT SUM(APHD.Amount)
640: INTO l_discount_sum
641: FROM AP_Payment_Hist_Dists APHD,
642: AP_Payment_History_All APH
643: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
644: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
645: AND APH.Related_Event_ID = P_Related_Event_ID

Line 680: FROM AP_Payment_Hist_Dists APHD,

676:
677:
678: SELECT SUM(APHD.Invoice_Dist_Amount)
679: INTO l_discount_sum
680: FROM AP_Payment_Hist_Dists APHD,
681: AP_Payment_History_All APH
682: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
683: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
684: AND APH.Related_Event_ID = P_Related_Event_ID

Line 720: FROM AP_Payment_Hist_Dists APHD,

716:
717:
718: SELECT SUM(APHD.Bank_Curr_Amount)
719: INTO l_discount_sum
720: FROM AP_Payment_Hist_Dists APHD,
721: AP_Payment_History_All APH
722: WHERE APHD.Invoice_Distribution_ID = P_Invoice_Distribution_ID
723: AND APHD.Invoice_Payment_ID = P_Invoice_Payment_ID
724: AND APH.Related_Event_ID = P_Related_Event_ID

Line 769: FROM AP_Payment_Hist_Dists APHD,

765: SUM(APHD.Bank_Curr_Amount)
766: INTO l_pay_sum,
767: l_inv_dist_sum,
768: l_bank_curr_sum
769: FROM AP_Payment_Hist_Dists APHD,
770: AP_Payment_History_All APH
771: WHERE APHD.Invoice_Distribution_ID in ( /*bug8882706*/
772: select p_invoice_distribution_id from dual
773: union

Line 814: FROM AP_Payment_Hist_Dists APHD,

810: SUM(APHD.Bank_Curr_Amount)
811: INTO l_pay_sum,
812: l_inv_dist_sum,
813: l_bank_curr_sum
814: FROM AP_Payment_Hist_Dists APHD,
815: AP_Payment_History_All APH
816: WHERE APHD.Invoice_Distribution_ID in ( /*bug8882706*/
817: select p_invoice_distribution_id from dual
818: union

Line 858: FROM AP_Payment_Hist_Dists APHD,

854: SUM(APHD.Bank_Curr_Amount)
855: INTO l_pay_sum,
856: l_inv_dist_sum,
857: l_bank_curr_sum
858: FROM AP_Payment_Hist_Dists APHD,
859: AP_Payment_History_All APH
860: WHERE APHD.Invoice_Distribution_ID in ( /*bug 8882706*/
861: select p_invoice_distribution_id from dual
862: union

Line 948: FROM AP_Payment_Hist_Dists APHD

944: , SUM( APHD.Cleared_Base_Amount )
945: INTO l_pay_sum
946: , l_inv_dist_sum
947: , l_bank_curr_sum
948: FROM AP_Payment_Hist_Dists APHD
949: , AP_Payment_History_All APH
950: WHERE APHD.Invoice_Distribution_ID IN
951: (SELECT p_invoice_distribution_id
952: FROM dual

Line 986: FROM AP_Payment_Hist_Dists APHD

982: , SUM( APHD.Cleared_Base_Amount )
983: INTO l_pay_sum
984: , l_inv_dist_sum
985: , l_bank_curr_sum
986: FROM AP_Payment_Hist_Dists APHD
987: , AP_Payment_History_All APH
988: WHERE APHD.Invoice_Distribution_ID IN
989: (SELECT p_invoice_distribution_id
990: FROM dual

Line 1024: FROM AP_Payment_Hist_Dists APHD

1020: , SUM( APHD.Cleared_Base_Amount )
1021: INTO l_pay_sum
1022: , l_inv_dist_sum
1023: , l_bank_curr_sum
1024: FROM AP_Payment_Hist_Dists APHD
1025: , AP_Payment_History_All APH
1026: WHERE APHD.Invoice_Distribution_ID IN
1027: (SELECT p_invoice_distribution_id
1028: FROM dual

Line 1263: FROM AP_Payment_Hist_Dists APHD,

1259: SELECT SUM(--DECODE(APHD.Pay_Dist_Lookup_Code,
1260: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
1261: APHD.Amount)
1262: INTO l_paid_acctd_amt
1263: FROM AP_Payment_Hist_Dists APHD,
1264: AP_Invoice_Distributions_All AID,
1265: AP_Payment_History_All APH
1266: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1267: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 1294: FROM AP_Payment_Hist_Dists APHD,

1290: SELECT SUM(--DECODE(APHD.Pay_Dist_Lookup_Code,
1291: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
1292: APHD.Amount)
1293: INTO l_paid_acctd_amt
1294: FROM AP_Payment_Hist_Dists APHD,
1295: AP_Invoice_Distributions_All AID,
1296: AP_Payment_History_All APH
1297: WHERE AID.Invoice_ID = p_inv_rec.invoice_id
1298: AND AID.Invoice_Distribution_ID = APHD.Invoice_Distribution_ID

Line 1325: FROM AP_Payment_Hist_Dists APHD,

1321: SELECT SUM(--DECODE(APHD.Pay_Dist_Lookup_Code,
1322: --'EXCHANGE RATE VARIANCE', -1 * APHD.Amount,
1323: APHD.Amount)
1324: INTO l_paid_acctd_amt
1325: FROM AP_Payment_Hist_Dists APHD,
1326: AP_Invoice_Distributions_All AID,
1327: AP_Payment_History_All APH,
1328: AP_INVOICE_PAYMENTS_ALL AIP
1329: WHERE AID.Invoice_ID = p_inv_rec.invoice_id