[Home] [Help]
View: MRP_AP_SAFETY_STOCKS_V
Product: | MRP - Master Scheduling/MRP |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT MSS.INVENTORY_ITEM_ID
, MSS.ORGANIZATION_ID
, MSS.EFFECTIVITY_DATE
, MSS.SAFETY_STOCK_QUANTITY
, MSS.RN RN3
, MSIK.RN RN2
, MP.RN RN1
FROM MRP_AP_MRP_PARAS_SN MP
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_SFTY_STKS_SN MSS
WHERE MSS.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MSS.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MSS.ORGANIZATION_ID= MP.ORGANIZATION_ID
Columns
Name |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
EFFECTIVITY_DATE |
SAFETY_STOCK_QUANTITY |
RN3 |
RN2 |
RN1 |