View: MSC_SAFETY_STOCKS_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SAFETY_STOCKS_V

View Text

SELECT MSS.ROWID ROW_ID
, MSI.SR_INVENTORY_ITEM_ID
, MSI.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSI.DESCRIPTION
, MSI.UOM_CODE
, MSS.ORGANIZATION_ID
, MSS.SR_INSTANCE_ID
, MSS.PERIOD_START_DATE EFFECTIVITY_DATE
, MSS.LAST_UPDATE_DATE
, MSS.LAST_UPDATED_BY
, MSS.CREATION_DATE
, MSS.CREATED_BY
, MSS.LAST_UPDATE_LOGIN
, MSI.SAFETY_STOCK_CODE
, MSS.SAFETY_STOCK_QUANTITY
, MSS.REQUEST_ID
, MSS.PROGRAM_APPLICATION_ID
, MSS.PROGRAM_ID
, MSS.PROGRAM_UPDATE_DATE
, MSS.PROJECT_ID
, MSS.TASK_ID
, MSS.PLANNING_GROUP
, MSS.PLAN_ID
, MSC_GET_NAME.TASK(MSS.TASK_ID
, MSS.PROJECT_ID
, MSS.ORGANIZATION_ID
, MSS.PLAN_ID
, MSS.SR_INSTANCE_ID)
, MSC_GET_NAME.PROJECT(MSS.PROJECT_ID
, MSS.ORGANIZATION_ID
, MSS.PLAN_ID
, MSS.SR_INSTANCE_ID)
, DECODE(MSI.SAFETY_STOCK_CODE
, 1
, 'NON-MRP PLANNED PERCENT'
, 2
, 'MRP PLANNED PERCENT'
, NULL)
FROM MSC_SAFETY_STOCKS MSS
, MSC_SYSTEM_ITEMS MSI
WHERE MSS.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MSS.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSS.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSS.PLAN_ID = MSI.PLAN_ID

Columns