VIEW: APPS.MRPFV_PLAN_SAFETY_STOCKS

Source

View Text - Preformatted

SELECT PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , SA.COMPILE_DESIGNATOR PLAN_NAME , '_KF:INV:MSTK:SY' , SA.PERIOD_START_DATE , SA.SAFETY_STOCK_QUANTITY , SA.ORGANIZATION_ID , SA.INVENTORY_ITEM_ID , SA.LAST_UPDATE_DATE , SA.LAST_UPDATED_BY , SA.CREATION_DATE , SA.CREATED_BY FROM MTL_PARAMETERS PA ,HR_ALL_ORGANIZATION_UNITS AL ,MTL_SYSTEM_ITEMS SY ,MRP_SAFETY_STOCK SA WHERE SA.ORGANIZATION_ID = SY.ORGANIZATION_ID AND SA.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID AND SA.ORGANIZATION_ID = PA.ORGANIZATION_ID AND SA.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:SA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, SA.COMPILE_DESIGNATOR PLAN_NAME
, '_KF:INV:MSTK:SY'
, SA.PERIOD_START_DATE
, SA.SAFETY_STOCK_QUANTITY
, SA.ORGANIZATION_ID
, SA.INVENTORY_ITEM_ID
, SA.LAST_UPDATE_DATE
, SA.LAST_UPDATED_BY
, SA.CREATION_DATE
, SA.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MRP_SAFETY_STOCK SA
WHERE SA.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND SA.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND SA.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SA.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND '_SEC:SA.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY