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 2706: -- ap_payment_history_all aph

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

Line 2726: ap_payment_history_all aph,

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
2730: AND zx_dist.recoverable_flag = p_tax_rec_flag

Line 2769: ap_payment_history_all aph,

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
2771: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2772: AND aid.line_type_lookup_code = 'ITEM'
2773: AND aip.invoice_id = aid.invoice_id

Line 2804: -- ap_payment_history_all aph

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

Line 2823: -- ap_payment_history_all aph

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
2827: -- AND aip.invoice_payment_id = aphd.invoice_payment_id

Line 2843: ap_payment_history_all aph,

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
2847: AND aid.tax_recoverable_flag = p_tax_rec_flag

Line 2875: ap_payment_history_all aph,

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
2877: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2878: AND aid.line_type_lookup_code = 'TAX'
2879: AND aip.invoice_id = aid.invoice_id

Line 2900: ap_payment_history_all aph

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
2904: AND aip.invoice_payment_id = aphd.invoice_payment_id

Line 2918: ap_payment_history_all aph,

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
2920: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2921: AND aid.invoice_distribution_id = p_trx_line_id
2922: AND aip.invoice_id = aid.invoice_id

Line 2939: ap_payment_history_all aph

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
2943: AND aip.invoice_payment_id = aphd.invoice_payment_id

Line 2957: ap_payment_history_all aph,

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
2959: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2960: AND aid.invoice_distribution_id = p_tax_line_id
2961: AND aip.invoice_id = aid.invoice_id

Line 2978: ap_payment_history_all aph,

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
2982: and ((zx_dist.trx_line_dist_id = aid.invoice_distribution_id) OR

Line 2999: ap_payment_history_all aph,

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
3001: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
3002: AND aid.invoice_distribution_id = p_trx_line_dist_id
3003: AND aip.invoice_id = aid.invoice_id

Line 3018: ap_payment_history_all aph

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
3022: AND aphd.PAY_DIST_LOOKUP_CODE = 'DISCOUNT'

Line 3035: ap_payment_history_all aph

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
3039: AND aip.invoice_payment_id = aphd.invoice_payment_id

Line 3055: ap_payment_history_all aph,

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
3057: WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
3058: -- AND aid.invoice_distribution_id = p_tax_line_id
3059: AND aid.detail_tax_dist_id = p_dist_id