View: MTL_OPSM_SYSTEM_ITEMS_V

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.MTL_OPSM_SYSTEM_ITEMS_V

View Text

SELECT MSIB.ROWID ROW_ID
, MSIB.INVENTORY_ITEM_ID
, MSIB.ORGANIZATION_ID
, MSIBK.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSIBK.DESCRIPTION
, MSIBK.PRIMARY_UOM_CODE
, MCRV.CROSS_REFERENCE OPSM_INTEGRATED
, MCRV.CREATION_DATE
, MCRV.LAST_UPDATE_DATE
, MSIB.ATTRIBUTE_CATEGORY
, MSIB.ATTRIBUTE1
, MSIB.ATTRIBUTE2
, MSIB.ATTRIBUTE3
, MSIB.ATTRIBUTE4
, MSIB.ATTRIBUTE5
, MSIB.ATTRIBUTE6
, MSIB.ATTRIBUTE7
, MSIB.ATTRIBUTE8
, MSIB.ATTRIBUTE9
, MSIB.ATTRIBUTE10
, MSIB.ATTRIBUTE11
, MSIB.ATTRIBUTE12
, MSIB.ATTRIBUTE13
, MSIB.ATTRIBUTE14
, MSIB.ATTRIBUTE15
, MSIB.ATTRIBUTE16
, MSIB.ATTRIBUTE17
, MSIB.ATTRIBUTE18
, MSIB.ATTRIBUTE19
, MSIB.ATTRIBUTE20
, MSIB.ATTRIBUTE21
, MSIB.ATTRIBUTE22
, MSIB.ATTRIBUTE23
, MSIB.ATTRIBUTE24
, MSIB.ATTRIBUTE25
, MSIB.ATTRIBUTE26
, MSIB.ATTRIBUTE27
, MSIB.ATTRIBUTE28
, MSIB.ATTRIBUTE29
, MSIB.ATTRIBUTE30
, MSIB.GLOBAL_ATTRIBUTE_CATEGORY
, MSIB.GLOBAL_ATTRIBUTE1
, MSIB.GLOBAL_ATTRIBUTE2
, MSIB.GLOBAL_ATTRIBUTE3
, MSIB.GLOBAL_ATTRIBUTE4
, MSIB.GLOBAL_ATTRIBUTE5
, MSIB.GLOBAL_ATTRIBUTE6
, MSIB.GLOBAL_ATTRIBUTE7
, MSIB.GLOBAL_ATTRIBUTE8
, MSIB.GLOBAL_ATTRIBUTE9
, MSIB.GLOBAL_ATTRIBUTE10
, MSIB.GLOBAL_ATTRIBUTE11
, MSIB.GLOBAL_ATTRIBUTE12
, MSIB.GLOBAL_ATTRIBUTE13
, MSIB.GLOBAL_ATTRIBUTE14
, MSIB.GLOBAL_ATTRIBUTE15
, MSIB.GLOBAL_ATTRIBUTE16
, MSIB.GLOBAL_ATTRIBUTE17
, MSIB.GLOBAL_ATTRIBUTE18
, MSIB.GLOBAL_ATTRIBUTE19
, MSIB.GLOBAL_ATTRIBUTE20 FROM MTL_SYSTEM_ITEMS_B MSIB
, MTL_SYSTEM_ITEMS_B_KFV MSIBK
, MTL_PARAMETERS MP
, MTL_CROSS_REFERENCES_VL MCRV WHERE MSIBK.ROW_ID = CHARTOROWID(ROWIDTOCHAR(MSIB.ROWID)) AND MSIB.ORGANIZATION_ID = MP.ORGANIZATION_ID AND MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID AND MCRV.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID AND MP.OPSM_ENABLED_FLAG ='Y' AND MCRV.CROSS_REFERENCE_TYPE='OPSM INTEGRATED' AND MCRV.CROSS_REFERENCE='YES' AND MSIB.LOT_CONTROL_CODE=2 AND MSIB.INVENTORY_ITEM_ID=MCRV.INVENTORY_ITEM_ID