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