[Home] [Help]
View: MTL_CATEGORY_SETS_ALL_V
View Text
SELECT V.CATEGORY_SET_ID
, V.STRUCTURE_ID
, V.VALIDATE_FLAG
, V.CONTROL_LEVEL
, V.DEFAULT_CATEGORY_ID
, V.LAST_UPDATE_DATE
, V.LAST_UPDATED_BY
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATE_LOGIN
, V.REQUEST_ID
, V.PROGRAM_APPLICATION_ID
, V.PROGRAM_ID
, V.PROGRAM_UPDATE_DATE
, V.CATEGORY_SET_NAME
, V.DESCRIPTION
, V.MULT_ITEM_CAT_ASSIGN_FLAG
FROM MTL_CATEGORY_SETS_VL V
Columns
Name |
CATEGORY_SET_ID |
STRUCTURE_ID |
VALIDATE_FLAG |
CONTROL_LEVEL |
DEFAULT_CATEGORY_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
REQUEST_ID |
PROGRAM_APPLICATION_ID |
PROGRAM_ID |
PROGRAM_UPDATE_DATE |
CATEGORY_SET_NAME |
DESCRIPTION |
MULT_ITEM_CAT_ASSIGN_FLAG |