[Home] [Help]
View: INVBV_ITEM_CATEGORY_TYPES
View Text
SELECT CA.CATEGORY_SET_NAME
, CA.DESCRIPTION
, '_LA:CA.VALIDATE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:CA.CONTROL_LEVEL:MFG_LOOKUPS:INV_CATEGORY_SET_CONTROL_LEVEL:MEANING'
, CA.CATEGORY_SET_ID
, CA.STRUCTURE_ID
, CA.DEFAULT_CATEGORY_ID
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
, CA.CREATION_DATE
, CA.CREATED_BY
FROM MTL_CATEGORY_SETS CA
Columns
Name |
CATEGORY_TYPE_NAME |
DESCRIPTION |
"_LA:ENFORCE_CATEGORIES_FLAG" |
"_LA:CONTROL_LEVEL" |
CATEGORY_SET_ID |
STRUCTURE_ID |
DEFAULT_CATEGORY_ID |
LAST_UPDATED_DATE |
LAST_UPDATED_BY |
CREATED_DATE |
CREATED_BY |