VIEW: APPS.EDW_ITEMS_CATEGORY_FKV

Source

View Text - Preformatted

SELECT mic.inventory_item_id, mic.organization_id, sets.control_level, sets.category_set_name, mic.category_id, mic.last_update_date from mtl_categories cat, mtl_item_categories mic, mtl_category_sets sets WHERE cat.category_id = mic.category_id and mic.category_set_id = sets.category_set_id

View Text - HTML Formatted

SELECT MIC.INVENTORY_ITEM_ID
, MIC.ORGANIZATION_ID
, SETS.CONTROL_LEVEL
, SETS.CATEGORY_SET_NAME
, MIC.CATEGORY_ID
, MIC.LAST_UPDATE_DATE
FROM MTL_CATEGORIES CAT
, MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_SETS SETS
WHERE CAT.CATEGORY_ID = MIC.CATEGORY_ID
AND MIC.CATEGORY_SET_ID = SETS.CATEGORY_SET_ID