DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

Line 3293: AND NOT EXISTS ( SELECT 'X' FROM ZX_OUTPUT_CLASSIFICATIONS_V

3289: ,(CASE WHEN (LST.TAX_EXEMPTION_CONTROL <> 'E' OR LST.TAX_EXEMPTION_CONTROL IS NULL)
3290: AND LST.EXEMPT_REASON_CODE IS NOT NULL
3291: THEN 'Y' ELSE 'N' END) ERC_NULL_ERROR
3292: ,(CASE WHEN LST.TAX_CLASSIFICATION_CODE IS NOT NULL
3293: AND NOT EXISTS ( SELECT 'X' FROM ZX_OUTPUT_CLASSIFICATIONS_V
3294: WHERE LST.TAX_CLASSIFICATION_CODE = LOOKUP_CODE
3295: AND ORG_ID IN (HDR.OPERATING_UNIT_ID, -99))
3296: THEN 'N' ELSE 'Y' END) TCC_VALID
3297: ,(CASE WHEN LST.RENEWAL_TYPE_CODE IS NOT NULL