APPS.ZX_VALIDATE_API_PKG dependencies on ZX_FC_INTENDED_USE_V

Line 4207: FROM ZX_FC_INTENDED_USE_V

4203: -- Bug 4703541
4204: nvl2(lines_gt.line_intended_use,
4205: CASE WHEN (NOT EXISTS
4206: (SELECT 1
4207: FROM ZX_FC_INTENDED_USE_V
4208: WHERE classification_code = lines_gt.line_intended_use
4209: AND (country_code IS NULL
4210: OR country_code = header.default_taxation_country))
4211: )

Line 4222: FROM ZX_FC_INTENDED_USE_V

4218: -- Bug 4703541
4219: CASE WHEN lines_gt.line_intended_use IS NOT NULL AND
4220: (EXISTS
4221: (SELECT 1
4222: FROM ZX_FC_INTENDED_USE_V
4223: WHERE classification_code = lines_gt.line_intended_use
4224: AND (country_code IS NULL
4225: OR country_code = header.default_taxation_country)))
4226: THEN CASE WHEN (NOT EXISTS

Line 4228: FROM ZX_FC_INTENDED_USE_V

4224: AND (country_code IS NULL
4225: OR country_code = header.default_taxation_country)))
4226: THEN CASE WHEN (NOT EXISTS
4227: (SELECT 1
4228: FROM ZX_FC_INTENDED_USE_V
4229: WHERE classification_code = lines_gt.line_intended_use
4230: AND (country_code IS NULL
4231: OR country_code = header.default_taxation_country)
4232: AND nvl(lines_gt.trx_line_date, header.trx_date)

Line 4245: FROM ZX_FC_INTENDED_USE_V

4241: -- Check for Intended Use - eTax modelFC code Country Consistency
4242: CASE WHEN lines_gt.line_intended_use IS NOT NULL AND
4243: (EXISTS
4244: (SELECT 1
4245: FROM ZX_FC_INTENDED_USE_V
4246: WHERE classification_code = lines_gt.line_intended_use
4247: AND country_code IS NOT NULL))
4248: THEN CASE WHEN (NOT EXISTS
4249: (SELECT 1

Line 4250: FROM ZX_FC_INTENDED_USE_V

4246: WHERE classification_code = lines_gt.line_intended_use
4247: AND country_code IS NOT NULL))
4248: THEN CASE WHEN (NOT EXISTS
4249: (SELECT 1
4250: FROM ZX_FC_INTENDED_USE_V
4251: WHERE classification_code = lines_gt.line_intended_use
4252: AND country_code IS NOT NULL
4253: AND country_code = header.default_taxation_country))
4254: THEN 'Y'