[Home] [Help]
View: INVBV_ITEM_CATEGORY_TYPE_ASGNS
View Text
SELECT CASET.CATEGORY_SET_NAME
, '_KF:INV:MCAT:CA'
, CASEVA.CATEGORY_SET_ID
, CASEVA.CATEGORY_ID
, CASEVA.LAST_UPDATE_DATE
, CASEVA.LAST_UPDATED_BY
, CASEVA.CREATION_DATE
, CASEVA.CREATED_BY
FROM MTL_CATEGORY_SETS CASET
, MTL_CATEGORIES CA
, MTL_CATEGORY_SET_VALID_CATS CASEVA
WHERE CASEVA.CATEGORY_ID = CA.CATEGORY_ID
AND CASEVA.CATEGORY_SET_ID = CASET.CATEGORY_SET_ID WITH READ ONLY
Columns
Name |
CATEGORY_TYPE_NAME |
"_KF:ITEM_CATEGORY_NAME" |
CATEGORY_ID |
CATEGORY_SET_ID |
LAST_UPDATED_DATE |
LAST_UPDATED_BY |
CREATED_DATE |
CREATED_BY |