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 473: AP_Payment_History_All APH,

469: -- 'TAX EXCHANGE RATE VARIANCE', -1*APHD.Invoice_Dist_Base_Amount,
470: APHD.Invoice_Dist_Base_Amount)
471: INTO l_sum_pay_dist_base_amt
472: FROM AP_Payment_Hist_Dists APHD,
473: AP_Payment_History_All APH,
474: AP_Invoice_Payments_All AIP
475: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
476: AND APHD.Pay_Dist_Lookup_Code IN
477: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING'))

Line 489: FROM Ap_Payment_History_All APH_REL

485: 'PAYMENT CLEARING ADJUSTED')
486: -- bug 9257606, ignore the event/payment if reversed
487: AND NVL(AIP.reversal_flag, 'N') <> 'Y'
488: AND NOT EXISTS (SELECT 'Event Reversed'
489: FROM Ap_Payment_History_All APH_REL
490: WHERE APH_REL.check_id = APH.check_id
491: AND NVL(APH_REL.related_event_id, APH_REL.accounting_event_id) =
492: NVL(APH.related_event_id, APH.accounting_event_id)
493: AND APH_REL.rev_pmt_hist_id IS NOT NULL);

Line 505: AP_Payment_History_All APH,

501: -- 'TAX EXCHANGE RATE VARIANCE', -1*APHD.Invoice_Dist_Base_Amount,
502: APHD.Invoice_Dist_Base_Amount)
503: INTO l_sum_pay_dist_base_amt
504: FROM AP_Payment_Hist_Dists APHD,
505: AP_Payment_History_All APH,
506: AP_Invoice_Payments_All AIP
507: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
508: AND APHD.Pay_Dist_Lookup_Code IN
509: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING' ))

Line 521: FROM Ap_Payment_History_All APH_REL

517: 'PAYMENT MATURITY ADJUSTED')
518: -- bug 9257606, ignore the event/payment if reversed
519: AND NVL(AIP.reversal_flag, 'N') <> 'Y'
520: AND NOT EXISTS (SELECT 'Event Reversed'
521: FROM Ap_Payment_History_All APH_REL
522: WHERE APH_REL.check_id = APH.check_id
523: AND NVL(APH_REL.related_event_id, APH_REL.accounting_event_id) =
524: NVL(APH.related_event_id, APH.accounting_event_id)
525: AND APH_REL.rev_pmt_hist_id IS NOT NULL);

Line 536: AP_Payment_History_All APH,

532: -- 'TAX EXCHANGE RATE VARIANCE', -1*APHD.Invoice_Dist_Base_Amount,
533: APHD.Invoice_Dist_Base_Amount)
534: INTO l_sum_pay_dist_base_amt
535: FROM AP_Payment_Hist_Dists APHD,
536: AP_Payment_History_All APH,
537: AP_Invoice_Payments_All AIP
538: WHERE ((APHD.Invoice_Distribution_ID = l_inv_dist_rec.invoice_distribution_id
539: AND APHD.Pay_Dist_Lookup_Code IN
540: ('CASH', 'DISCOUNT', 'FINAL PAYMENT ROUNDING' ))

Line 554: FROM Ap_Payment_History_All APH_REL

550: 'MANUAL REFUND ADJUSTED') --bug 10336668
551: -- bug 9257606, ignore the event/payment if reversed
552: AND NVL(AIP.reversal_flag, 'N') <> 'Y'
553: AND NOT EXISTS (SELECT 'Event Reversed'
554: FROM Ap_Payment_History_All APH_REL
555: WHERE APH_REL.check_id = APH.check_id
556: AND NVL(APH_REL.related_event_id, APH_REL.accounting_event_id) =
557: NVL(APH.related_event_id, APH.accounting_event_id)
558: AND APH_REL.rev_pmt_hist_id IS NOT NULL);

Line 978: AP_Payment_History_All APH

974: l_disc_clr_rate_sum_amt,
975: l_err_clr_rate_sum_amt,
976: l_chrg_clr_rate_sum_amt
977: FROM AP_Payment_Hist_Dists APHD,
978: AP_Payment_History_All APH
979: WHERE APH.Related_Event_ID = p_pay_hist_rec.Related_Event_ID
980: AND APHD.Invoice_Payment_ID = p_inv_pay_rec.Invoice_Payment_ID
981: AND APHD.Payment_History_ID = APH.Payment_History_ID
982: AND APHD.Invoice_Distribution_ID IN

Line 1037: AP_PAYMENT_HISTORY_ALL APH

1033: 'AWT', APHD.Invoice_Dist_Base_Amount,
1034: 'DISCOUNT', APHD.Invoice_Dist_Base_Amount, 0))
1035: INTO l_pay_sum_amt,l_max_dist_id,l_inv_rate_sum_full_amt
1036: FROM AP_PAYMENT_HIST_DISTS APHD,
1037: AP_PAYMENT_HISTORY_ALL APH
1038: WHERE
1039: APHD.PAYMENT_HISTORY_ID =APH.PAYMENT_HISTORY_ID
1040: ANd APHD.INVOICE_PAYMENT_ID =p_inv_pay_rec.Invoice_Payment_ID --6614295
1041: AND APHD.Invoice_Distribution_ID IN

Line 2403: AP_Payment_History_All APH,

2399: -- Get the paid base amounts for the payment event
2400: SELECT SUM(APHD.Paid_Base_Amount)
2401: INTO l_sum_pay_paid_base_amt
2402: FROM AP_Payment_Hist_Dists APHD,
2403: AP_Payment_History_All APH,
2404: AP_Payment_History_All APH1
2405: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_pay_pmt_history_id
2406: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
2407: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 2404: AP_Payment_History_All APH1

2400: SELECT SUM(APHD.Paid_Base_Amount)
2401: INTO l_sum_pay_paid_base_amt
2402: FROM AP_Payment_Hist_Dists APHD,
2403: AP_Payment_History_All APH,
2404: AP_Payment_History_All APH1
2405: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_pay_pmt_history_id
2406: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
2407: AND APHD.Payment_History_ID = APH.Payment_History_ID
2408: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')

Line 2422: AP_Payment_History_All APH,

2418: SUM(APHD.Matured_Base_Amount)
2419: INTO l_sum_mat_paid_base_amt,
2420: l_sum_mat_mat_base_amt
2421: FROM AP_Payment_Hist_Dists APHD,
2422: AP_Payment_History_All APH,
2423: AP_Payment_History_All APH1
2424: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_mat_pmt_history_id
2425: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
2426: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 2423: AP_Payment_History_All APH1

2419: INTO l_sum_mat_paid_base_amt,
2420: l_sum_mat_mat_base_amt
2421: FROM AP_Payment_Hist_Dists APHD,
2422: AP_Payment_History_All APH,
2423: AP_Payment_History_All APH1
2424: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_mat_pmt_history_id
2425: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
2426: AND APHD.Payment_History_ID = APH.Payment_History_ID
2427: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')

Line 2446: AP_Payment_History_All APH,

2442: SUM(APHD.Matured_Base_Amount)
2443: INTO l_sum_clr_paid_base_amt,
2444: l_sum_clr_mat_base_amt
2445: FROM AP_Payment_Hist_Dists APHD,
2446: AP_Payment_History_All APH,
2447: AP_Payment_History_All APH1
2448: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_clr_pmt_history_id
2449: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
2450: AND APHD.Payment_History_ID = APH.Payment_History_ID

Line 2447: AP_Payment_History_All APH1

2443: INTO l_sum_clr_paid_base_amt,
2444: l_sum_clr_mat_base_amt
2445: FROM AP_Payment_Hist_Dists APHD,
2446: AP_Payment_History_All APH,
2447: AP_Payment_History_All APH1
2448: WHERE APH1.Payment_History_ID = ap_accounting_pay_pkg.g_clr_pmt_history_id
2449: AND APH.Related_Event_ID = APH1.Accounting_Event_ID
2450: AND APHD.Payment_History_ID = APH.Payment_History_ID
2451: AND APHD.Pay_Dist_Lookup_Code IN ('CASH')

Line 3038: AP_Payment_History_All APH

3034: -- Get the paid base amount for the payment event
3035: SELECT SUM(APHD.Paid_Base_Amount)
3036: INTO l_sum_pay_paid_base_amt
3037: FROM AP_Payment_Hist_Dists APHD,
3038: AP_Payment_History_All APH
3039: WHERE APH.Related_Event_ID = p_pay_hist_rec.Related_Event_ID
3040: AND APHD.Payment_History_ID = APH.Payment_History_ID
3041: AND Invoice_Distribution_ID IN
3042: (SELECT AID.Invoice_Distribution_ID

Line 3052: AP_Payment_History_All APH

3048: -- Get the cleared base amount for the payment clearing event
3049: SELECT SUM(APHD.Cleared_Base_Amount)
3050: INTO l_sum_pay_clrd_base_amt
3051: FROM AP_Payment_Hist_Dists APHD,
3052: AP_Payment_History_All APH
3053: WHERE APH.Related_Event_ID = p_clr_hist_rec.related_event_id
3054: AND APHD.Payment_History_ID = APH.Payment_History_ID
3055: AND Invoice_Distribution_ID IN
3056: (SELECT AID.Invoice_Distribution_ID

Line 3068: AP_Payment_History_All APH

3064: -- Get the paid base amount for the payment event
3065: SELECT SUM(APHD.Paid_Base_Amount)
3066: INTO l_sum_pay_paid_base_amt
3067: FROM AP_Payment_Hist_Dists APHD,
3068: AP_Payment_History_All APH
3069: WHERE APH.Related_Event_ID = p_pay_hist_rec.Related_Event_ID
3070: AND APHD.Payment_History_ID = APH.Payment_History_ID
3071: AND Invoice_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id
3072: AND Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT', 'TOTAL PAYMENT ROUNDING',

Line 3079: AP_Payment_History_All APH

3075: -- Get the cleared base amount for the payment clearing event
3076: SELECT SUM(APHD.Cleared_Base_Amount)
3077: INTO l_sum_pay_clrd_base_amt
3078: FROM AP_Payment_Hist_Dists APHD,
3079: AP_Payment_History_All APH
3080: WHERE APH.Related_Event_ID = p_clr_hist_rec.related_event_id
3081: AND APHD.Payment_History_ID = APH.Payment_History_ID
3082: AND Invoice_Distribution_ID = p_prepay_dist_rec.prepay_distribution_id
3083: AND Pay_Dist_Lookup_Code IN ('CASH', 'DISCOUNT', 'AWT', 'TOTAL CLEARING ROUNDING',

Line 3268: ap_payment_history_all aph

3264: SELECT SUM(DECODE(l_transaction_type, 'CLEARING' , nvl(cleared_base_amount,0),
3265: 'MATURITY' , nvl(matured_base_amount,0),nvl(paid_base_amount,0)))
3266: INTO l_sum_cash_amt
3267: FROM ap_payment_hist_dists aphd,
3268: ap_payment_history_all aph
3269: WHERE aph.payment_history_id = aphd.payment_history_id
3270: AND aph.check_id = P_XLA_Event_Rec.source_id_int_1
3271: AND aph.accounting_event_id = P_XLA_Event_Rec.event_id
3272: AND aph.posted_flag <> 'Y'

Line 3299: FROM AP_Payment_History_All APH

3295: l_pay_hist_rec.Bank_Currency_Code,
3296: l_pay_hist_rec.Bank_To_Base_XRate_Type,
3297: l_pay_hist_rec.Bank_To_Base_XRate_Date,
3298: l_pay_hist_rec.Bank_To_Base_XRate
3299: FROM AP_Payment_History_All APH
3300: WHERE APH.Accounting_Event_ID = p_xla_event_rec.event_id;
3301:
3302:
3303: -- Getting the distribution for inserting the rounding distribution