VIEW: APPS.ZX_FC_PRODUCT_FISCAL_V

Source

View Text - Preformatted

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'
   

View Text - HTML Formatted

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'