VIEW: APPS.MTL_CATEGORY_SETS_V

Source

View Text - Preformatted

SELECT MCS.ROWID ROW_ID , MCS.CATEGORY_SET_ID , T.CATEGORY_SET_NAME , T.DESCRIPTION , MCS.STRUCTURE_ID , MCS.VALIDATE_FLAG , MCS.CONTROL_LEVEL , MCS.DEFAULT_CATEGORY_ID , MCS.LAST_UPDATE_DATE , MCS.LAST_UPDATED_BY , MCS.CREATION_DATE , MCS.CREATED_BY , MCS.LAST_UPDATE_LOGIN , MCS.REQUEST_ID , MCS.PROGRAM_APPLICATION_ID , MCS.PROGRAM_ID , MCS.PROGRAM_UPDATE_DATE , FIFS.ID_FLEX_STRUCTURE_NAME STRUCTURE_NAME , ML.MEANING CONTROL_LEVEL_DISP , MCS.MULT_ITEM_CAT_ASSIGN_FLAG , MCS.CONTROL_LEVEL_UPDATEABLE_FLAG , MCS.MULT_ITEM_CAT_UPDATEABLE_FLAG , MCS.VALIDATE_FLAG_UPDATEABLE_FLAG , MCS.HIERARCHY_ENABLED FROM MTL_CATEGORY_SETS_TL T , MTL_CATEGORY_SETS_B MCS , FND_ID_FLEX_STRUCTURES_VL FIFS , MFG_LOOKUPS ML WHERE MCS.CATEGORY_SET_ID = T.CATEGORY_SET_ID AND T.LANGUAGE = userenv('LANG') AND MCS.STRUCTURE_ID = FIFS.ID_FLEX_NUM AND FIFS.APPLICATION_ID = 401 AND FIFS.ID_FLEX_CODE = 'MCAT' AND MCS.CONTROL_LEVEL = ML.LOOKUP_CODE AND ML.LOOKUP_TYPE = 'ITEM_CONTROL_LEVEL_GUI'

View Text - HTML Formatted

SELECT MCS.ROWID ROW_ID
, MCS.CATEGORY_SET_ID
, T.CATEGORY_SET_NAME
, T.DESCRIPTION
, MCS.STRUCTURE_ID
, MCS.VALIDATE_FLAG
, MCS.CONTROL_LEVEL
, MCS.DEFAULT_CATEGORY_ID
, MCS.LAST_UPDATE_DATE
, MCS.LAST_UPDATED_BY
, MCS.CREATION_DATE
, MCS.CREATED_BY
, MCS.LAST_UPDATE_LOGIN
, MCS.REQUEST_ID
, MCS.PROGRAM_APPLICATION_ID
, MCS.PROGRAM_ID
, MCS.PROGRAM_UPDATE_DATE
, FIFS.ID_FLEX_STRUCTURE_NAME STRUCTURE_NAME
, ML.MEANING CONTROL_LEVEL_DISP
, MCS.MULT_ITEM_CAT_ASSIGN_FLAG
, MCS.CONTROL_LEVEL_UPDATEABLE_FLAG
, MCS.MULT_ITEM_CAT_UPDATEABLE_FLAG
, MCS.VALIDATE_FLAG_UPDATEABLE_FLAG
, MCS.HIERARCHY_ENABLED
FROM MTL_CATEGORY_SETS_TL T
, MTL_CATEGORY_SETS_B MCS
, FND_ID_FLEX_STRUCTURES_VL FIFS
, MFG_LOOKUPS ML
WHERE MCS.CATEGORY_SET_ID = T.CATEGORY_SET_ID
AND T.LANGUAGE = USERENV('LANG')
AND MCS.STRUCTURE_ID = FIFS.ID_FLEX_NUM
AND FIFS.APPLICATION_ID = 401
AND FIFS.ID_FLEX_CODE = 'MCAT'
AND MCS.CONTROL_LEVEL = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'ITEM_CONTROL_LEVEL_GUI'