APPS.ZX_VALIDATE_API_PKG dependencies on ZX_INPUT_CLASSIFICATIONS_V

Line 4570: FROM zx_input_classifications_v

4566: THEN 'Y'
4567: ELSE
4568: CASE WHEN lines_gt.input_tax_classification_code IS NOT NULL
4569: AND NOT EXISTS (SELECT 1
4570: FROM zx_input_classifications_v
4571: WHERE lookup_code = lines_gt.input_tax_classification_code
4572: AND org_id in (header.internal_organization_id, -99))
4573: THEN
4574: CASE WHEN (lines_gt.source_application_id IS NOT NULL AND

Line 4577: FROM zx_input_classifications_v

4573: THEN
4574: CASE WHEN (lines_gt.source_application_id IS NOT NULL AND
4575: lines_gt.source_event_class_code = 'INTERCOMPANY_TRX' AND
4576: NOT EXISTS (SELECT 1
4577: FROM zx_input_classifications_v
4578: WHERE UPPER(lookup_code) =
4579: UPPER(lines_gt.input_tax_classification_code)
4580: AND org_id in (header.internal_organization_id, -99)))
4581: THEN 'Y'

Line 4601: FROM zx_input_classifications_v

4597: THEN 'Y'
4598: ELSE
4599: CASE WHEN lines_gt.input_tax_classification_code IS NOT NULL
4600: AND NOT EXISTS (SELECT 1
4601: FROM zx_input_classifications_v
4602: WHERE lookup_code = lines_gt.input_tax_classification_code
4603: AND org_id in (header.internal_organization_id, -99)
4604: AND lines_gt.tax_date
4605: BETWEEN start_date_active

Line 4612: FROM zx_input_classifications_v

4608: THEN
4609: CASE WHEN (lines_gt.source_application_id IS NOT NULL AND
4610: lines_gt.source_event_class_code = 'INTERCOMPANY_TRX' AND
4611: NOT EXISTS (SELECT 1
4612: FROM zx_input_classifications_v
4613: WHERE UPPER(lookup_code) =
4614: UPPER(lines_gt.input_tax_classification_code)
4615: AND org_id in (header.internal_organization_id, -99)
4616: AND lines_gt.tax_date

Line 4637: FROM zx_input_classifications_v

4633: AND enabled_flag = 'Y')
4634: THEN 'Y'
4635: ELSE CASE WHEN lines_gt.input_tax_classification_code IS NOT NULL
4636: AND NOT EXISTS (SELECT 1
4637: FROM zx_input_classifications_v
4638: WHERE lookup_code = lines_gt.input_tax_classification_code
4639: AND org_id in (header.internal_organization_id, -99)
4640: AND enabled_flag = 'Y')
4641: THEN CASE WHEN (lines_gt.source_application_id IS NOT NULL AND

Line 4644: FROM zx_input_classifications_v

4640: AND enabled_flag = 'Y')
4641: THEN CASE WHEN (lines_gt.source_application_id IS NOT NULL AND
4642: lines_gt.source_event_class_code = 'INTERCOMPANY_TRX' AND
4643: NOT EXISTS (SELECT 1
4644: FROM zx_input_classifications_v
4645: WHERE UPPER(lookup_code) =
4646: UPPER(lines_gt.input_tax_classification_code)
4647: AND org_id in (header.internal_organization_id, -99)
4648: AND enabled_flag = 'Y'))