View: EDW_ITEMS_ITEM_ORG_FKV

Product:	ENG - Engineering
Description:	This view holds item - organization information
Implementation/DBA Data:	APPS.EDW_ITEMS_ITEM_ORG_FKV

View Text

SELECT MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, MSI.CONCATENATED_SEGMENTS||'-'||MP.ORGANIZATION_CODE||'-'||'IORG' FROM MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PARAMETERS MP
WHERE MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID

Columns