View: INVBV_ITEM_CATEGORY_ASGNS

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

View Text

SELECT AL.NAME
, PA.ORGANIZATION_CODE
, '_KF:INV:MSTK:SY'
, CA.CATEGORY_SET_NAME
, 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_CATEGORY_SETS CA
, 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 = CA.CATEGORY_SET_ID
AND '_SEC:IT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns