[Home] [Help]
View: EDW_ITEMS_ITEM_REV_FKV
| Product: | ENG - Engineering |
|---|
| Description: | This view holds item - revision information |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
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
| Name |
| INVENTORY_ITEM_ID |
| ORGANIZATION_ID |
| REVISION |
| ITEM_REV_FK |