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_HISTORY_ALL

Line 2349: ap_payment_history_all aph

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
2353: IN (SELECT distribution_line_number

Line 2381: ap_payment_history_all aph,

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
2385: AND aid.distribution_line_number

Line 2413: ap_payment_history_all aph

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
2417: IN (SELECT distribution_line_number

Line 2434: ap_payment_history_all aph,

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
2438: AND aid.distribution_line_number

Line 2457: ap_payment_history_all aph

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
2461: AND aid.invoice_distribution_id = p_trx_line_id

Line 2475: ap_payment_history_all aph,

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
2479: -- AND aid.distribution_line_number

Line 2495: ap_payment_history_all aph

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
2499: AND aid.invoice_distribution_id = p_tax_line_id

Line 2513: ap_payment_history_all aph,

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
2517: -- AND aid.distribution_line_number

Line 2533: ap_payment_history_all aph

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
2537: AND aid.invoice_distribution_id = p_trx_line_id

Line 2551: ap_payment_history_all aph,

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
2555: -- AND aid.distribution_line_number

Line 2571: ap_payment_history_all aph

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
2575: AND aid.invoice_distribution_id = p_tax_line_id

Line 2589: ap_payment_history_all aph,

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
2593: -- AND aid.distribution_line_number