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_INVOICE_PAYMENTS_ALL

Line 2347: ap_invoice_payments_all aip,

2343: SELECT sum(aphd.amount), -- discount amount (entered)
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

Line 2380: ap_invoice_payments_all aip,

2376: xal.accounted_dr -xal.entered_cr
2377: -- discount entered amount (replace this with new xla colum names)
2378: FROM ap_invoice_distributions_all aid,
2379: -- ap_invoices_all ai,
2380: ap_invoice_payments_all aip,
2381: ap_payment_history_all aph,
2382: xla_ae_lines xal
2383: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2384: AND aid.invoice_id = aip.invoice_id

Line 2411: ap_invoice_payments_all aip,

2407: SELECT sum(aphd.amount), -- discount amount (entered)
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

Line 2433: ap_invoice_payments_all aip,

2429: xal.accounted_dr -xal.entered_cr
2430: -- discount entered amount (replace this with new xla colum names)
2431: FROM ap_invoice_distributions_all aid,
2432: -- ap_invoices_all ai,
2433: ap_invoice_payments_all aip,
2434: ap_payment_history_all aph,
2435: xla_ae_lines xal
2436: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2437: AND aid.invoice_id = aip.invoice_id

Line 2455: ap_invoice_payments_all aip,

2451: SELECT sum(aphd.amount), -- discount amount (entered)
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

Line 2474: ap_invoice_payments_all aip,

2470: xal.accounted_dr -xal.entered_cr
2471: -- discount entered amount (replace this with new xla colum names)
2472: FROM ap_invoice_distributions_all aid,
2473: -- ap_invoices_all ai,
2474: ap_invoice_payments_all aip,
2475: ap_payment_history_all aph,
2476: xla_ae_lines xal
2477: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2478: AND aid.invoice_id = aip.invoice_id

Line 2493: ap_invoice_payments_all aip,

2489: SELECT sum(aphd.amount), -- discount amount (entered)
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

Line 2512: ap_invoice_payments_all aip,

2508: xal.accounted_dr -xal.entered_cr
2509: -- discount entered amount (replace this with new xla colum names)
2510: FROM ap_invoice_distributions_all aid,
2511: -- ap_invoices_all ai,
2512: ap_invoice_payments_all aip,
2513: ap_payment_history_all aph,
2514: xla_ae_lines xal
2515: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2516: AND aid.invoice_id = aip.invoice_id

Line 2531: ap_invoice_payments_all aip,

2527: SELECT sum(aphd.amount), -- discount amount (entered)
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

Line 2550: ap_invoice_payments_all aip,

2546: xal.accounted_dr -xal.entered_cr
2547: -- discount entered amount (replace this with new xla colum names)
2548: FROM ap_invoice_distributions_all aid,
2549: -- ap_invoices_all ai,
2550: ap_invoice_payments_all aip,
2551: ap_payment_history_all aph,
2552: xla_ae_lines xal
2553: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2554: AND aid.invoice_id = aip.invoice_id

Line 2569: ap_invoice_payments_all aip,

2565: SELECT sum(aphd.amount), -- discount amount (entered)
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

Line 2588: ap_invoice_payments_all aip,

2584: xal.accounted_dr -xal.entered_cr
2585: -- discount entered amount (replace this with new xla colum names)
2586: FROM ap_invoice_distributions_all aid,
2587: -- ap_invoices_all ai,
2588: ap_invoice_payments_all aip,
2589: ap_payment_history_all aph,
2590: xla_ae_lines xal
2591: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2592: AND aid.invoice_id = aip.invoice_id