View: EDWBV_ITEM_ITEMREV_LCV

Product:	ENG - Engineering
Description:	This view contains item revisions.
Implementation/DBA Data:	APPS.EDWBV_ITEM_ITEMREV_LCV

View Text

SELECT MTR.REVISION||'-'|| MTR.INVENTORY_ITEM_ID ||'-'|| MTR.ORGANIZATION_ID ||'-'|| INST.INSTANCE_CODE
, INST.INSTANCE_CODE
, MTR.INVENTORY_ITEM_ID||'-'||MTR.ORGANIZATION_ID||'-'||INST.INSTANCE_CODE
, SUBSTR(MTR.REVISION || '(' || MTI.CONCATENATED_SEGMENTS || '
, ' ||MP.ORGANIZATION_CODE || ')'
, 1
, 240)
, SUBSTR(MTR.REVISION || '(' || MTI.CONCATENATED_SEGMENTS || '
, ' || MP.ORGANIZATION_CODE || ')'
, 1
, 80)
, SUBSTR(MTR.REVISION || '(' || MTI.CONCATENATED_SEGMENTS || '
, ' || MP.ORGANIZATION_CODE || ')'
, 1
, 240)
, MTR.EFFECTIVITY_DATE
, MTR.CREATION_DATE
, MTR.LAST_UPDATE_DATE
, NULL
, '_DF:INV:MTL_ITEM_REVISIONS:MTR'
FROM MTL_SYSTEM_ITEMS_KFV MTI
, MTL_ITEM_REVISIONS MTR
, MTL_PARAMETERS MP
, EDW_LOCAL_INSTANCE INST
WHERE MTI.INVENTORY_ITEM_ID = MTR.INVENTORY_ITEM_ID
AND MTI.ORGANIZATION_ID = MTR.ORGANIZATION_ID
AND MTR.ORGANIZATION_ID = MP.ORGANIZATION_ID WITH READ ONLY

Columns