eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTL_OPSM_SYSTEM_ITEMS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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