DBA Data[Home] [Help]

APPS.OKS_IMPORT_VALIDATE dependencies on ZX_OUTPUT_CLASSIFICATIONS_V

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

3237: ,(CASE WHEN (LST.TAX_EXEMPTION_CONTROL <> 'E' OR LST.TAX_EXEMPTION_CONTROL IS NULL)
3238: AND LST.EXEMPT_REASON_CODE IS NOT NULL
3239: THEN 'Y' ELSE 'N' END) ERC_NULL_ERROR
3240: ,(CASE WHEN LST.TAX_CLASSIFICATION_CODE IS NOT NULL
3241: AND NOT EXISTS ( SELECT 'X' FROM ZX_OUTPUT_CLASSIFICATIONS_V
3242: WHERE LST.TAX_CLASSIFICATION_CODE = LOOKUP_CODE
3243: AND ORG_ID IN (HDR.OPERATING_UNIT_ID, -99))
3244: THEN 'N' ELSE 'Y' END) TCC_VALID
3245: ,(CASE WHEN LST.RENEWAL_TYPE_CODE IS NOT NULL