View: INVFV_ITEM_CATEGORY_TYPE_ASGNS

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.INVFV_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
AND CA.STRUCTURE_ID = (SELECT STRUCTURE_ID
FROM MTL_CATEGORY_SETS MCS
WHERE MCS.CATEGORY_SET_ID = CASET.CATEGORY_SET_ID) WITH READ ONLY

Columns