View: MTL_SAFETY_STOCKS_VIEW

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

View Text

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'

Columns