View: INVFV_ITEM_CATEGORY_ASGNS

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.INVFV_ITEM_CATEGORY_ASGNS

View Text

SELECT AL.NAME ORGANIZATION_NAME
, PA.ORGANIZATION_CODE
, '_KF:INV:MSTK:SY'
, CASET.CATEGORY_SET_NAME
, '_KF:INV:MCAT:CA'
, IT.INVENTORY_ITEM_ID
, IT.ORGANIZATION_ID
, IT.CATEGORY_SET_ID
, IT.CATEGORY_ID
, IT.LAST_UPDATE_DATE
, IT.LAST_UPDATED_BY
, IT.CREATION_DATE
, IT.CREATED_BY
FROM MTL_CATEGORIES CA
, MTL_CATEGORY_SETS CASET
, MTL_SYSTEM_ITEMS SY
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_ITEM_CATEGORIES IT
WHERE IT.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND IT.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND IT.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND IT.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND IT.CATEGORY_SET_ID = CASET.CATEGORY_SET_ID
AND IT.CATEGORY_ID =CA.CATEGORY_ID
AND '_SEC:IT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns