DBA Data[Home] [Help]

APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on AP_INV_DISTS_TARGET

Line 2924: FROM AP_INV_DISTS_TARGET dists

2920: WHEN lines.line_type_lookup_code <> 'TAX'
2921: THEN NULL
2922: WHEN NOT EXISTS
2923: (SELECT /*+ index(dists AP_INVOICE_DISTRIBUTIONS_U1) */ 1
2924: FROM AP_INV_DISTS_TARGET dists
2925: WHERE dists.invoice_id = lines.invoice_id
2926: AND dists.invoice_line_number = lines.line_number
2927: AND dists.charge_applicable_to_dist_id IS NOT NULL
2928: )

Line 3814: ap_inv_dists_target ap_dists,

3810: ,DECODE(lines.line_source,'MANUAL LINE ENTRY','TAX_AMOUNT',NULL) LAST_MANUAL_ENTRY --BUG7146063
3811: FROM ap_invoices_all inv,
3812: xla_upgrade_dates upd,
3813: fnd_currencies fnd_curr,
3814: ap_inv_dists_target ap_dists,
3815: ap_inv_dists_target ap_dists1,
3816: ap_invoice_lines_all lines1,
3817: ap_invoice_lines_all lines,
3818: zx_rates_b rates,

Line 3815: ap_inv_dists_target ap_dists1,

3811: FROM ap_invoices_all inv,
3812: xla_upgrade_dates upd,
3813: fnd_currencies fnd_curr,
3814: ap_inv_dists_target ap_dists,
3815: ap_inv_dists_target ap_dists1,
3816: ap_invoice_lines_all lines1,
3817: ap_invoice_lines_all lines,
3818: zx_rates_b rates,
3819: zx_regimes_b regimes,