Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MRPFV_PLAN_SAFETY_STOCKS |
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