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.ZX_AP_POPULATE_PKG dependencies on AP_PAYMENT_HIST_DISTS

Line 2348: ap_payment_hist_dists aphd,

2344: sum(aphd.paid_base_amount) -- discount amount (accounted)
2345: FROM ap_invoice_distributions_all aid,
2346: -- ap_invoices_all ai,
2347: ap_invoice_payments_all aip,
2348: ap_payment_hist_dists aphd,
2349: ap_payment_history_all aph
2350: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2351: AND aid.invoice_id = aip.invoice_id
2352: AND aid.distribution_line_number

Line 2412: ap_payment_hist_dists aphd,

2408: sum(aphd.paid_base_amount) -- discount amount (accounted)
2409: FROM ap_invoice_distributions_all aid,
2410: -- ap_invoices_all ai,
2411: ap_invoice_payments_all aip,
2412: ap_payment_hist_dists aphd,
2413: ap_payment_history_all aph
2414: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2415: AND aid.invoice_id = aip.invoice_id
2416: AND aid.distribution_line_number

Line 2456: ap_payment_hist_dists aphd,

2452: sum(aphd.paid_base_amount) -- discount amount (accounted)
2453: FROM ap_invoice_distributions_all aid,
2454: -- ap_invoices_all ai,
2455: ap_invoice_payments_all aip,
2456: ap_payment_hist_dists aphd,
2457: ap_payment_history_all aph
2458: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2459: AND aid.invoice_id = aip.invoice_id
2460: -- AND aid.distribution_line_number

Line 2494: ap_payment_hist_dists aphd,

2490: sum(aphd.paid_base_amount) -- discount amount (accounted)
2491: FROM ap_invoice_distributions_all aid,
2492: -- ap_invoices_all ai,
2493: ap_invoice_payments_all aip,
2494: ap_payment_hist_dists aphd,
2495: ap_payment_history_all aph
2496: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2497: AND aid.invoice_id = aip.invoice_id
2498: -- AND aid.distribution_line_number

Line 2532: ap_payment_hist_dists aphd,

2528: sum(aphd.paid_base_amount) -- discount amount (accounted)
2529: FROM ap_invoice_distributions_all aid,
2530: -- ap_invoices_all ai,
2531: ap_invoice_payments_all aip,
2532: ap_payment_hist_dists aphd,
2533: ap_payment_history_all aph
2534: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2535: AND aid.invoice_id = aip.invoice_id
2536: -- AND aid.distribution_line_number

Line 2570: ap_payment_hist_dists aphd,

2566: sum(aphd.paid_base_amount) -- discount amount (accounted)
2567: FROM ap_invoice_distributions_all aid,
2568: -- ap_invoices_all ai,
2569: ap_invoice_payments_all aip,
2570: ap_payment_hist_dists aphd,
2571: ap_payment_history_all aph
2572: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2573: AND aid.invoice_id = aip.invoice_id
2574: -- AND aid.distribution_line_number