View: MTL_CATEGORY_SETS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_CATEGORY_SETS_V

View Text

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'

Columns