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 2453: FROM ap_invoice_distributions_all ap_dist,

2449: c_trx_line_dist_id NUMBER
2450: ) IS
2451: SELECT SUM(nvl(lnk.UNROUNDED_ENTERED_DR,0) - nvl(lnk.UNROUNDED_ENTERED_CR,0)),
2452: SUM(nvl(lnk.UNROUNDED_ACCOUNTED_DR,0) - nvl(lnk.UNROUNDED_ACCOUNTED_CR,0))
2453: FROM ap_invoice_distributions_all ap_dist,
2454: xla_distribution_links lnk,
2455: xla_ae_headers aeh,
2456: xla_ae_lines ael
2457: WHERE ap_dist.invoice_id = c_trx_id

Line 2702: -- FROM ap_invoice_distributions_all aid,

2698:
2699: -- CURSOR taxable_hdr_csr IS
2700: -- SELECT sum(aphd.amount), -- discount amount (entered)
2701: -- sum(aphd.paid_base_amount) -- discount amount (accounted)
2702: -- FROM ap_invoice_distributions_all aid,
2703: -- ap_invoices_all ai,
2704: -- ap_invoice_payments_all aip,
2705: -- ap_payment_hist_dists aphd,
2706: -- ap_payment_history_all aph

Line 2711: -- FROM ap_invoice_distributions_all

2707: -- WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2708: -- AND aid.invoice_id = aip.invoice_id
2709: -- AND aid.distribution_line_number
2710: -- IN (SELECT distribution_line_number
2711: -- FROM ap_invoice_distributions_all
2712: -- WHERE invoice_id = p_trx_id
2713: -- AND line_type_lookup_code = 'ITEM')
2714: -- AND aip.invoice_payment_id = aphd.invoice_payment_id
2715: -- AND aphd.PAY_DIST_LOOKUP_CODE = 'DISCOUNT'

Line 2723: FROM ap_invoice_distributions_all aid,

2719:
2720: CURSOR taxable_hdr_csr IS
2721: SELECT sum(aphd.amount), -- discount amount (entered)
2722: sum(aphd.paid_base_amount) -- discount amount (accounted)
2723: FROM ap_invoice_distributions_all aid,
2724: ap_invoice_payments_all aip,
2725: ap_payment_hist_dists aphd,
2726: ap_payment_history_all aph,
2727: zx_rec_nrec_dist zx_dist

Line 2766: FROM ap_invoice_distributions_all aid,

2762: xal.entered_dr - xal.entered_cr ,
2763: -- discount entered amount (replace this with new xla colum names)
2764: xal.accounted_dr -xal.entered_cr
2765: -- discount entered amount (replace this with new xla colum names)
2766: FROM ap_invoice_distributions_all aid,
2767: -- ap_invoices_all ai,
2768: ap_invoice_payments_all aip,
2769: ap_payment_history_all aph,
2770: xla_ae_lines xal

Line 2776: -- FROM ap_invoice_distributions_all

2772: AND aid.line_type_lookup_code = 'ITEM'
2773: AND aip.invoice_id = aid.invoice_id
2774: -- AND aid.distribution_line_number
2775: -- IN (SELECT distribution_line_number
2776: -- FROM ap_invoice_distributions_all
2777: -- WHERE invoice_id = p_trx_id
2778: -- AND line_type_lookup_code = 'ITEM')
2779: AND xal.application_id = 200
2780: AND xal.ledger_id = p_ledger_id

Line 2800: -- FROM ap_invoice_distributions_all aid,

2796:
2797: -- CURSOR tax_hdr_csr IS
2798: -- SELECT sum(aphd.amount), -- discount amount (entered)
2799: -- sum(aphd.paid_base_amount) -- discount amount (accounted)
2800: -- FROM ap_invoice_distributions_all aid,
2801: -- ap_invoices_all ai,
2802: -- ap_invoice_payments_all aip,
2803: -- ap_payment_hist_dists aphd,
2804: -- ap_payment_history_all aph

Line 2809: -- FROM ap_invoice_distributions_all

2805: -- WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2806: -- AND aid.invoice_id = aip.invoice_id
2807: -- AND aid.distribution_line_number
2808: -- IN (SELECT distribution_line_number
2809: -- FROM ap_invoice_distributions_all
2810: -- WHERE invoice_id = p_trx_id
2811: -- AND line_type_lookup_code in ('REC_TAX', 'NONREC_TAX'))
2812: -- AND aip.invoice_payment_id = aphd.invoice_payment_id
2813: -- AND aphd.PAY_DIST_LOOKUP_CODE = 'DISCOUNT'

Line 2820: -- FROM ap_invoice_distributions_all aid,

2816: -- AND aph.check_id = aip.check_id
2817: -- New --
2818: -- SELECT sum(aphd.amount), -- discount amount (entered)
2819: -- sum(aphd.paid_base_amount) -- discount amount (accounted)
2820: -- FROM ap_invoice_distributions_all aid,
2821: -- ap_invoice_payments_all aip,
2822: -- ap_payment_hist_dists aphd,
2823: -- ap_payment_history_all aph
2824: -- WHERE aid.invoice_id = p_trx_id -- ai.invoice_id

Line 2840: FROM ap_invoice_distributions_all aid,

2836:
2837: CURSOR tax_hdr_csr IS
2838: SELECT sum(aphd.amount), -- discount amount (entered)
2839: sum(aphd.paid_base_amount) -- discount amount (accounted)
2840: FROM ap_invoice_distributions_all aid,
2841: ap_invoice_payments_all aip,
2842: ap_payment_hist_dists aphd,
2843: ap_payment_history_all aph,
2844: zx_rec_nrec_dist zx_dist

Line 2872: FROM ap_invoice_distributions_all aid,

2868: xal.entered_dr - xal.entered_cr ,
2869: -- discount entered amount (replace this with new xla colum names)
2870: xal.accounted_dr -xal.entered_cr
2871: -- discount entered amount (replace this with new xla colum names)
2872: FROM ap_invoice_distributions_all aid,
2873: -- ap_invoices_all ai,
2874: ap_invoice_payments_all aip,
2875: ap_payment_history_all aph,
2876: xla_ae_lines xal

Line 2882: -- FROM ap_invoice_distributions_all

2878: AND aid.line_type_lookup_code = 'TAX'
2879: AND aip.invoice_id = aid.invoice_id
2880: -- AND aid.distribution_line_number
2881: -- IN (SELECT distribution_line_number
2882: -- FROM ap_invoice_distributions_all
2883: -- WHERE invoice_id = p_trx_id
2884: -- AND line_type_lookup_code = 'TAX')
2885: AND xal.application_id = 200
2886: AND xal.accounting_class_code = 'DISCOUNT'

Line 2896: FROM ap_invoice_distributions_all aid,

2892:
2893: CURSOR taxable_line_csr IS
2894: SELECT sum(aphd.amount), -- discount amount (entered)
2895: sum(aphd.paid_base_amount) -- discount amount (accounted)
2896: FROM ap_invoice_distributions_all aid,
2897: -- ap_invoices_all ai,
2898: ap_invoice_payments_all aip,
2899: ap_payment_hist_dists aphd,
2900: ap_payment_history_all aph

Line 2915: FROM ap_invoice_distributions_all aid,

2911: xal.entered_dr - xal.entered_cr ,
2912: -- discount entered amount (replace this with new xla colum names)
2913: xal.accounted_dr -xal.entered_cr
2914: -- discount entered amount (replace this with new xla colum names)
2915: FROM ap_invoice_distributions_all aid,
2916: -- ap_invoices_all ai,
2917: ap_invoice_payments_all aip,
2918: ap_payment_history_all aph,
2919: xla_ae_lines xal

Line 2935: FROM ap_invoice_distributions_all aid,

2931:
2932: CURSOR tax_line_csr IS
2933: SELECT sum(aphd.amount), -- discount amount (entered)
2934: sum(aphd.paid_base_amount) -- discount amount (accounted)
2935: FROM ap_invoice_distributions_all aid,
2936: -- ap_invoices_all ai,
2937: ap_invoice_payments_all aip,
2938: ap_payment_hist_dists aphd,
2939: ap_payment_history_all aph

Line 2954: FROM ap_invoice_distributions_all aid,

2950: xal.entered_dr - xal.entered_cr ,
2951: -- discount entered amount (replace this with new xla colum names)
2952: xal.accounted_dr -xal.entered_cr
2953: -- discount entered amount (replace this with new xla colum names)
2954: FROM ap_invoice_distributions_all aid,
2955: -- ap_invoices_all ai,
2956: ap_invoice_payments_all aip,
2957: ap_payment_history_all aph,
2958: xla_ae_lines xal

Line 2974: FROM ap_invoice_distributions_all aid,

2970:
2971: CURSOR taxable_dist_csr IS
2972: SELECT sum(aphd.amount), -- discount amount (entered)
2973: sum(aphd.paid_base_amount) -- discount amount (accounted)
2974: FROM ap_invoice_distributions_all aid,
2975: -- ap_invoices_all ai,
2976: ap_invoice_payments_all aip,
2977: ap_payment_hist_dists aphd,
2978: ap_payment_history_all aph,

Line 2996: FROM ap_invoice_distributions_all aid,

2992: SELECT SUM(NVL(xal.entered_dr,0) - NVL(xal.entered_cr,0)) ,
2993: -- discount entered amount (replace this with new xla colum names)
2994: SUM(NVL(xal.accounted_dr,0) - NVL(xal.accounted_cr,0))
2995: -- discount entered amount (replace this with new xla colum names)
2996: FROM ap_invoice_distributions_all aid,
2997: -- ap_invoices_all ai,
2998: ap_invoice_payments_all aip,
2999: ap_payment_history_all aph,
3000: xla_ae_lines xal

Line 3015: FROM ap_invoice_distributions_all aid,

3011:
3012: CURSOR taxable_disc_sys_cur IS
3013: SELECT sum(aphd.amount),
3014: sum(aphd.paid_base_amount)
3015: FROM ap_invoice_distributions_all aid,
3016: ap_invoice_payments_all aip,
3017: ap_payment_hist_dists aphd,
3018: ap_payment_history_all aph
3019: WHERE aid.invoice_id = p_trx_id

Line 3031: FROM ap_invoice_distributions_all aid,

3027:
3028: CURSOR tax_dist_csr IS
3029: SELECT sum(aphd.amount), -- discount amount (entered)
3030: sum(aphd.paid_base_amount) -- discount amount (accounted)
3031: FROM ap_invoice_distributions_all aid,
3032: -- ap_invoices_all ai,
3033: ap_invoice_payments_all aip,
3034: ap_payment_hist_dists aphd,
3035: ap_payment_history_all aph

Line 3052: FROM ap_invoice_distributions_all aid,

3048: SELECT SUM(NVL(xal.entered_dr,0) - NVL(xal.entered_cr,0)) ,
3049: -- discount entered amount (replace this with new xla colum names)
3050: SUM(NVL(xal.accounted_dr,0) - NVL(xal.accounted_cr,0))
3051: -- discount entered amount (replace this with new xla colum names)
3052: FROM ap_invoice_distributions_all aid,
3053: -- ap_invoices_all ai,
3054: ap_invoice_payments_all aip,
3055: ap_payment_history_all aph,
3056: xla_ae_lines xal