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_DISTRIBUTIONS_ALL

Line 2345: FROM ap_invoice_distributions_all aid,

2341:
2342: CURSOR taxable_hdr_csr IS
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

Line 2354: FROM ap_invoice_distributions_all

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
2354: FROM ap_invoice_distributions_all
2355: WHERE invoice_id = p_trx_id
2356: AND line_type_lookup_code = 'ITEM')
2357: AND aip.invoice_payment_id = aphd.invoice_payment_id
2358: AND aphd.PAY_DIST_LOOKUP_CODE = 'DISCOUNT'

Line 2378: FROM ap_invoice_distributions_all aid,

2374: SELECT xal.entered_dr - xal.entered_cr ,
2375: -- discount entered amount (replace this with new xla colum names)
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

Line 2387: FROM ap_invoice_distributions_all

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
2386: IN (SELECT distribution_line_number
2387: FROM ap_invoice_distributions_all
2388: WHERE invoice_id = p_trx_id
2389: AND line_type_lookup_code = 'ITEM')
2390: AND aip.invoice_payment_id = xal.Upg_Tax_Reference_ID3
2391: AND aid.old_dist_line_number = xal.Upg_Tax_Reference_ID2

Line 2409: FROM ap_invoice_distributions_all aid,

2405:
2406: CURSOR tax_hdr_csr IS
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

Line 2418: FROM ap_invoice_distributions_all

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
2418: FROM ap_invoice_distributions_all
2419: WHERE invoice_id = p_trx_id
2420: AND line_type_lookup_code = 'TAX')
2421: AND aip.invoice_payment_id = aphd.invoice_payment_id
2422: AND aphd.PAY_DIST_LOOKUP_CODE = 'DISCOUNT'

Line 2431: FROM ap_invoice_distributions_all aid,

2427: SELECT xal.entered_dr - xal.entered_cr ,
2428: -- discount entered amount (replace this with new xla colum names)
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

Line 2440: FROM ap_invoice_distributions_all

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
2439: IN (SELECT distribution_line_number
2440: FROM ap_invoice_distributions_all
2441: WHERE invoice_id = p_trx_id
2442: AND line_type_lookup_code = 'TAX')
2443: AND aip.invoice_payment_id = xal.Upg_Tax_Reference_ID3
2444: AND aid.old_dist_line_number = xal.Upg_Tax_Reference_ID2

Line 2453: FROM ap_invoice_distributions_all aid,

2449:
2450: CURSOR taxable_line_csr IS
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

Line 2472: FROM ap_invoice_distributions_all aid,

2468: SELECT xal.entered_dr - xal.entered_cr ,
2469: -- discount entered amount (replace this with new xla colum names)
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

Line 2491: FROM ap_invoice_distributions_all aid,

2487:
2488: CURSOR tax_line_csr IS
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

Line 2510: FROM ap_invoice_distributions_all aid,

2506: SELECT xal.entered_dr - xal.entered_cr ,
2507: -- discount entered amount (replace this with new xla colum names)
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

Line 2529: FROM ap_invoice_distributions_all aid,

2525:
2526: CURSOR taxable_dist_csr IS
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

Line 2548: FROM ap_invoice_distributions_all aid,

2544: SELECT xal.entered_dr - xal.entered_cr ,
2545: -- discount entered amount (replace this with new xla colum names)
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

Line 2567: FROM ap_invoice_distributions_all aid,

2563:
2564: CURSOR tax_dist_csr IS
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

Line 2586: FROM ap_invoice_distributions_all aid,

2582: SELECT xal.entered_dr - xal.entered_cr ,
2583: -- discount entered amount (replace this with new xla colum names)
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