[Home] [Help]
View: MRP_I2_FORECASTS_V
Product: | MRP - Master Scheduling/MRP |
Description: | A Rhythm view supporting information regarding forecasts |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT SUBSTR( MRP_I2_ERP.GET_PARAMETER('MRP_I2_L_DEMAND_PREFIX'
, F.ORGANIZATION_ID
, 1) || MRP_I2_ERP.GET_PARAMETER( 'MRP_I2_P_DELIMITER'
, F.ORGANIZATION_ID) || F.TRANSACTION_ID || MRP_I2_ERP.GET_PARAMETER('MRP_I2_P_DELIMITER'
, F.ORGANIZATION_ID) || TO_CHAR(F.FORECAST_DATE)
, 1
, 240)
, PM.PART_NUMBER
, F.INVENTORY_ITEM_ID
, F.ORGANIZATION_ID
, GREATEST(F.FORECAST_DATE
, MRP_I2_ERP.GET_START_DATE(F.ORGANIZATION_ID))
, F.CURRENT_FORECAST_QUANTITY * (F.CONFIDENCE_PERCENTAGE/100)
, F.FORECAST_DESIGNATOR
, MRP_I2.CALCULATE_PRIORITY( 'FORECAST'
, GREATEST(F.FORECAST_DATE
, MRP_I2_ERP.GET_START_DATE(F.ORGANIZATION_ID))
, F.ORGANIZATION_ID)
, SUBSTR( MRP_I2_ERP.GET_PARAMETER('CONSUME_FCST_IN_RHYTHM'
, F.ORGANIZATION_ID)
, 1
, 240)
FROM MRP_I2_PART_MASTER_V PM
, MRP_RHX_DAILY_FORECASTS_V F
WHERE F.FORECAST_DATE + 0 >= MRP_I2_ERP.GET_START_DATE(F.ORGANIZATION_ID) + PM.DEMAND_TIME_FENCE
AND F.ORGANIZATION_ID = PM.ORGANIZATION_ID
AND F.INVENTORY_ITEM_ID = PM.INVENTORY_ITEM_ID
AND F.FORECAST_SET = MRP_I2_ERP.GET_PARAMETER('FORECAST_SET'
, F.ORGANIZATION_ID)
AND MRP_I2_ERP.GET_PARAMETER('SCHEDULING_ONLY'
, PM.ORGANIZATION_ID) <> 'Y'
Columns
Name |
ORDER_NUMBER |
PART_NUMBER |
INVENTORY_ITEM_ID |
ORGANIZATION_ID |
FORECAST_DATE |
QUANTITY |
FORECAST_DESIGNATOR |
PRIORITY |
CONSUME_IN_RHYTHM |