VIEW: APPS.MTL_SAFETY_STOCKS_VIEW

Source

View Text - Preformatted

SELECT MSS.ROWID , MSS.INVENTORY_ITEM_ID , MSI.DESCRIPTION , MSI.PRIMARY_UOM_CODE , MSS.ORGANIZATION_ID , MSS.EFFECTIVITY_DATE , MSS.LAST_UPDATE_DATE , MSS.LAST_UPDATED_BY , MSS.CREATION_DATE , MSS.CREATED_BY , MSS.LAST_UPDATE_LOGIN , MSS.SAFETY_STOCK_CODE , L.MEANING , MSS.SAFETY_STOCK_QUANTITY , MSS.SAFETY_STOCK_PERCENT , MSS.SERVICE_LEVEL , MSS.ATTRIBUTE_CATEGORY , MSS.ATTRIBUTE1 , MSS.ATTRIBUTE2 , MSS.ATTRIBUTE3 , MSS.ATTRIBUTE4 , MSS.ATTRIBUTE5 , MSS.ATTRIBUTE6 , MSS.ATTRIBUTE7 , MSS.ATTRIBUTE8 , MSS.ATTRIBUTE9 , MSS.ATTRIBUTE10 , MSS.ATTRIBUTE11 , MSS.ATTRIBUTE12 , MSS.ATTRIBUTE13 , MSS.ATTRIBUTE14 , MSS.ATTRIBUTE15 , MSS.REQUEST_ID , MSS.PROGRAM_APPLICATION_ID , MSS.PROGRAM_ID , MSS.PROGRAM_UPDATE_DATE , MSS.FORECAST_DESIGNATOR , MSS.PROJECT_ID , MSS.TASK_ID FROM MTL_SYSTEM_ITEMS MSI, MTL_SAFETY_STOCKS MSS, MFG_LOOKUPS L WHERE MSI.INVENTORY_ITEM_ID = MSS.INVENTORY_ITEM_ID AND MSI.ORGANIZATION_ID = MSS.ORGANIZATION_ID AND L.LOOKUP_CODE (+) = MSS.SAFETY_STOCK_CODE AND L.LOOKUP_TYPE (+) = 'MTL_SAFETY_STOCK'

View Text - HTML Formatted

SELECT MSS.ROWID
, MSS.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, MSI.PRIMARY_UOM_CODE
, MSS.ORGANIZATION_ID
, MSS.EFFECTIVITY_DATE
, MSS.LAST_UPDATE_DATE
, MSS.LAST_UPDATED_BY
, MSS.CREATION_DATE
, MSS.CREATED_BY
, MSS.LAST_UPDATE_LOGIN
, MSS.SAFETY_STOCK_CODE
, L.MEANING
, MSS.SAFETY_STOCK_QUANTITY
, MSS.SAFETY_STOCK_PERCENT
, MSS.SERVICE_LEVEL
, MSS.ATTRIBUTE_CATEGORY
, MSS.ATTRIBUTE1
, MSS.ATTRIBUTE2
, MSS.ATTRIBUTE3
, MSS.ATTRIBUTE4
, MSS.ATTRIBUTE5
, MSS.ATTRIBUTE6
, MSS.ATTRIBUTE7
, MSS.ATTRIBUTE8
, MSS.ATTRIBUTE9
, MSS.ATTRIBUTE10
, MSS.ATTRIBUTE11
, MSS.ATTRIBUTE12
, MSS.ATTRIBUTE13
, MSS.ATTRIBUTE14
, MSS.ATTRIBUTE15
, MSS.REQUEST_ID
, MSS.PROGRAM_APPLICATION_ID
, MSS.PROGRAM_ID
, MSS.PROGRAM_UPDATE_DATE
, MSS.FORECAST_DESIGNATOR
, MSS.PROJECT_ID
, MSS.TASK_ID
FROM MTL_SYSTEM_ITEMS MSI
, MTL_SAFETY_STOCKS MSS
, MFG_LOOKUPS L
WHERE MSI.INVENTORY_ITEM_ID = MSS.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MSS.ORGANIZATION_ID
AND L.LOOKUP_CODE (+) = MSS.SAFETY_STOCK_CODE
AND L.LOOKUP_TYPE (+) = 'MTL_SAFETY_STOCK'