View: EDW_ITEMS_ITEM_REV_FKV

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

View Text

SELECT MSI.INVENTORY_ITEM_ID
, MSI.ORGANIZATION_ID
, MTR.REVISION
, MTR.REVISION||'-'|| MSI.CONCATENATED_SEGMENTS||'-'|| MP.ORGANIZATION_CODE
FROM MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PARAMETERS MP
, MTL_ITEM_REVISIONS MTR
WHERE MSI.INVENTORY_ITEM_ID = MTR.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MTR.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MTR.ORGANIZATION_ID

Columns