DBA Data[Home] [Help]

APPS.ZX_AP_POPULATE_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 2704: -- ap_invoice_payments_all aip,

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
2707: -- WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2708: -- AND aid.invoice_id = aip.invoice_id

Line 2724: ap_invoice_payments_all aip,

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

Line 2768: ap_invoice_payments_all aip,

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

Line 2802: -- ap_invoice_payments_all aip,

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
2805: -- WHERE aid.invoice_id = p_trx_id -- ai.invoice_id
2806: -- AND aid.invoice_id = aip.invoice_id

Line 2821: -- ap_invoice_payments_all aip,

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

Line 2841: ap_invoice_payments_all aip,

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

Line 2874: ap_invoice_payments_all aip,

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

Line 2898: ap_invoice_payments_all aip,

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

Line 2917: ap_invoice_payments_all aip,

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

Line 2937: ap_invoice_payments_all aip,

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

Line 2956: ap_invoice_payments_all aip,

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

Line 2976: ap_invoice_payments_all aip,

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

Line 2998: ap_invoice_payments_all aip,

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

Line 3016: ap_invoice_payments_all aip,

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

Line 3033: ap_invoice_payments_all aip,

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

Line 3054: ap_invoice_payments_all aip,

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