DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_INV_DISTS_TARGET

Line 985: FROM AP_INV_DISTS_TARGET dists

981: WHEN lines.line_type_lookup_code <> 'TAX'
982: THEN NULL
983: WHEN NOT EXISTS -- Tax Lines
984: (SELECT 1
985: FROM AP_INV_DISTS_TARGET dists
986: WHERE dists.invoice_id = lines.invoice_id
987: AND dists.invoice_line_number = lines.line_number
988: AND dists.charge_applicable_to_dist_id IS NOT NULL
989: )

Line 3152: FROM AP_INV_DISTS_TARGET dists

3148: WHEN lines.line_type_lookup_code <> 'TAX'
3149: THEN NULL
3150: WHEN NOT EXISTS -- Tax Lines
3151: (SELECT 1
3152: FROM AP_INV_DISTS_TARGET dists
3153: WHERE dists.invoice_id = lines.invoice_id
3154: AND dists.invoice_line_number = lines.line_number
3155: AND dists.charge_applicable_to_dist_id IS NOT NULL
3156: )