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 2705: -- ap_payment_hist_dists aphd,

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
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

Line 2725: ap_payment_hist_dists aphd,

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
2728: WHERE aid.invoice_id = p_trx_id
2729: AND aid.invoice_id = aip.invoice_id

Line 2803: -- ap_payment_hist_dists aphd,

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
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

Line 2822: -- ap_payment_hist_dists aphd,

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
2825: -- AND aid.invoice_id = aip.invoice_id
2826: -- AND aid.tax_recoverable_flag = p_tax_rec_flag

Line 2842: ap_payment_hist_dists aphd,

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
2845: WHERE aid.invoice_id = p_trx_id
2846: AND aid.invoice_id = aip.invoice_id

Line 2899: ap_payment_hist_dists aphd,

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
2901: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2902: AND aid.invoice_id = aip.invoice_id
2903: AND aid.invoice_distribution_id = p_trx_line_id

Line 2938: ap_payment_hist_dists aphd,

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
2940: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2941: AND aid.invoice_id = aip.invoice_id
2942: AND aid.invoice_distribution_id = p_tax_line_id

Line 2977: ap_payment_hist_dists aphd,

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,
2979: zx_rec_nrec_dist zx_dist
2980: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2981: AND aid.invoice_id = aip.invoice_id

Line 3017: ap_payment_hist_dists aphd,

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
3020: AND aid.invoice_id = aip.invoice_id
3021: AND aip.invoice_payment_id = aphd.invoice_payment_id

Line 3034: ap_payment_hist_dists aphd,

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
3036: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
3037: AND aid.invoice_id = aip.invoice_id
3038: AND aid.detail_tax_dist_id = p_dist_id