View: ZX_FC_INTENDED_USE_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.ZX_FC_INTENDED_USE_V

View Text

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'