VIEW: APPS.ZX_FC_INTENDED_USE_V

Source

View Text - Preformatted

SELECT REPLACE ( MC.CONCATENATED_SEGMENTS, FIFS.CONCATENATED_SEGMENT_DELIMITER, '') CODE, MCT.DESCRIPTION NAME, NULL COUNTRY_CODE, ZFT.EFFECTIVE_FROM EFFECTIVE_FROM, MC.END_DATE_ACTIVE EFFECTIVE_TO FROM MTL_CATEGORIES_TL MCT, MTL_CATEGORIES_B_KFV MC, FND_ID_FLEX_STRUCTURES_VL FIFS, ZX_FC_TYPES_B ZFT, MTL_CATEGORY_SETS_B MCS WHERE ZFT.CLASSIFICATION_TYPE_CODE = 'INTENDED_USE' AND MCS.CATEGORY_SET_ID = ZFT.OWNER_ID_NUM AND FIFS.ID_FLEX_NUM = MCS.STRUCTURE_ID AND MC.CATEGORY_ID = MCT.CATEGORY_ID AND MCT.LANGUAGE = USERENV ( 'LANG') AND MC.STRUCTURE_ID = FIFS.ID_FLEX_NUM AND FIFS.APPLICATION_ID = 401 AND FIFS.ID_FLEX_CODE = 'MCAT' AND MC.ENABLED_FLAG = 'Y' UNION SELECT FC.CLASSIFICATION_CODE CODE, FC.CLASSIFICATION_NAME NAME, FC.COUNTRY_CODE COUNTRY_CODE, FC.EFFECTIVE_FROM EFFECTIVE_FROM, FC.EFFECTIVE_TO EFFECTIVE_TO FROM ZX_FC_CODES_VL FC WHERE FC.CLASSIFICATION_TYPE_CODE = 'INTENDED_USE'
   

View Text - HTML Formatted

SELECT REPLACE ( MC.CONCATENATED_SEGMENTS
, FIFS.CONCATENATED_SEGMENT_DELIMITER
, '') CODE
, MCT.DESCRIPTION NAME
, NULL COUNTRY_CODE
, ZFT.EFFECTIVE_FROM EFFECTIVE_FROM
, MC.END_DATE_ACTIVE EFFECTIVE_TO
FROM MTL_CATEGORIES_TL MCT
, MTL_CATEGORIES_B_KFV MC
, FND_ID_FLEX_STRUCTURES_VL FIFS
, ZX_FC_TYPES_B ZFT
, MTL_CATEGORY_SETS_B MCS
WHERE ZFT.CLASSIFICATION_TYPE_CODE = 'INTENDED_USE'
AND MCS.CATEGORY_SET_ID = ZFT.OWNER_ID_NUM
AND FIFS.ID_FLEX_NUM = MCS.STRUCTURE_ID
AND MC.CATEGORY_ID = MCT.CATEGORY_ID
AND MCT.LANGUAGE = USERENV ( 'LANG')
AND MC.STRUCTURE_ID = FIFS.ID_FLEX_NUM
AND FIFS.APPLICATION_ID = 401
AND FIFS.ID_FLEX_CODE = 'MCAT'
AND MC.ENABLED_FLAG = 'Y' UNION SELECT FC.CLASSIFICATION_CODE CODE
, FC.CLASSIFICATION_NAME NAME
, FC.COUNTRY_CODE COUNTRY_CODE
, FC.EFFECTIVE_FROM EFFECTIVE_FROM
, FC.EFFECTIVE_TO EFFECTIVE_TO
FROM ZX_FC_CODES_VL FC
WHERE FC.CLASSIFICATION_TYPE_CODE = 'INTENDED_USE'