DBA Data[Home] [Help]

APPS.ZX_ON_FLY_TRX_UPGRADE_AP_PKG dependencies on AP_INV_DISTS_TARGET

Line 960: FROM AP_INV_DISTS_TARGET dists

956: WHEN lines.line_type_lookup_code <> 'TAX'
957: THEN NULL
958: WHEN NOT EXISTS -- Tax Lines
959: (SELECT 1
960: FROM AP_INV_DISTS_TARGET dists
961: WHERE dists.invoice_id = lines.invoice_id
962: AND dists.invoice_line_number = lines.line_number
963: AND dists.charge_applicable_to_dist_id IS NOT NULL
964: )

Line 3101: FROM AP_INV_DISTS_TARGET dists

3097: WHEN lines.line_type_lookup_code <> 'TAX'
3098: THEN NULL
3099: WHEN NOT EXISTS -- Tax Lines
3100: (SELECT 1
3101: FROM AP_INV_DISTS_TARGET dists
3102: WHERE dists.invoice_id = lines.invoice_id
3103: AND dists.invoice_line_number = lines.line_number
3104: AND dists.charge_applicable_to_dist_id IS NOT NULL
3105: )