[Home] [Help]
View: INVFV_ITEM_CATEGORIES
View Text
SELECT '_KF:INV:MCAT:CA'
, CA.DESCRIPTION
, CA.DISABLE_DATE
, ID.ID_FLEX_STRUCTURE_NAME
, '_DF:INV:MTL_CATEGORIES:CA'
, CA.CATEGORY_ID
, CA.STRUCTURE_ID
, CA.LAST_UPDATE_DATE
, CA.LAST_UPDATED_BY
, CA.CREATION_DATE
, CA.CREATED_BY
FROM MTL_CATEGORIES CA
, FND_ID_FLEX_STRUCTURES_VL ID
WHERE CA.STRUCTURE_ID = ID.ID_FLEX_NUM
AND ID.APPLICATION_ID = 401
AND ID.ID_FLEX_CODE = 'MCAT' WITH READ ONLY
Columns
Name |
"_KF:CATEGORY_NAME" |
DESCRIPTION |
END_EFFECTIVE_DATE |
CATEGORY_FLEX_STRUCTURE |
"_DF" |
CATEGORY_ID |
STRUCTURE_ID |
LAST_UPDATED_DATE |
LAST_UPDATED_BY |
CREATED_DATE |
CREATED_BY |