View: ZX_FC_PRODUCT_FISCAL_V

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

View Text

SELECT MC.CATEGORY_ID CATEGORY_ID
, MC.STRUCTURE_ID STRUCTURE_ID
, MCS.CATEGORY_SET_ID CATEGORY_SET_ID
, MCT.DESCRIPTION NAME
, REPLACE ( MC.CONCATENATED_SEGMENTS
, FIFS.CONCATENATED_SEGMENT_DELIMITER
, '') CODE
, FIFS.ID_FLEX_STRUCTURE_NAME STRUCTURE_NAME
, FIFS.ID_FLEX_STRUCTURE_CODE STRUCTURE_CODE
, ZCD.COUNTRY_CODE COUNTRY_CODE
, MC.END_DATE_ACTIVE EFFECTIVE_TO
FROM ZX_FC_COUNTRY_DEFAULTS ZCD
, MTL_CATEGORY_SETS_B MCS
, MTL_CATEGORIES_TL MCT
, FND_ID_FLEX_STRUCTURES_VL FIFS
, MTL_CATEGORIES_B_KFV MC
WHERE MCS.CATEGORY_SET_ID = ZCD.PRIMARY_INVENTORY_CATEGORY_SET
AND FIFS.ID_FLEX_NUM = MCS.STRUCTURE_ID
AND FIFS.APPLICATION_ID = 401
AND FIFS.ID_FLEX_CODE = 'MCAT'
AND MC.STRUCTURE_ID = FIFS.ID_FLEX_NUM
AND MC.CATEGORY_ID = MCT.CATEGORY_ID
AND MCT.LANGUAGE = USERENV ( 'LANG')
AND MC.ENABLED_FLAG = 'Y'