APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on AP_INV_DISTS_TARGET

Line 2985: FROM AP_INV_DISTS_TARGET dists

2981: WHEN lines.line_type_lookup_code <> 'TAX'
2982: THEN NULL
2983: WHEN NOT EXISTS
2984: (SELECT /*+ index(dists AP_INVOICE_DISTRIBUTIONS_U1) */ 1
2985: FROM AP_INV_DISTS_TARGET dists
2986: WHERE dists.invoice_id = lines.invoice_id
2987: AND dists.invoice_line_number = lines.line_number
2988: AND dists.charge_applicable_to_dist_id IS NOT NULL
2989: )

Line 3900: ap_inv_dists_target ap_dists,

3896: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3897: FROM ap_invoices_all inv,
3898: xla_upgrade_dates upd,
3899: fnd_currencies fnd_curr,
3900: ap_inv_dists_target ap_dists,
3901: ap_inv_dists_target ap_dists1,
3902: ap_invoice_lines_all lines1,
3903: ap_invoice_lines_all lines,
3904: zx_rates_b rates,

Line 3901: ap_inv_dists_target ap_dists1,

3897: FROM ap_invoices_all inv,
3898: xla_upgrade_dates upd,
3899: fnd_currencies fnd_curr,
3900: ap_inv_dists_target ap_dists,
3901: ap_inv_dists_target ap_dists1,
3902: ap_invoice_lines_all lines1,
3903: ap_invoice_lines_all lines,
3904: zx_rates_b rates,
3905: zx_regimes_b regimes,