Product: | ICX - Oracle iProcurement |
---|---|
Description: | Forecast Consumptions View |
Implementation/DBA Data: | APPS.ICX_MRP_FORECAST_UPDATES_V |
SELECT MFU.ROWID ROW_ID
, MFU.TRANSACTION_ID
, MFU.LAST_UPDATE_DATE
, MFU.LAST_UPDATED_BY
, MFU.CREATION_DATE
, MFU.CREATED_BY
, MFU.LAST_UPDATE_LOGIN
, MFU.INVENTORY_ITEM_ID
, MFU.ORGANIZATION_ID
, MFU.FORECAST_DESIGNATOR
, MFU.UPDATE_SALES_ORDER
, MFU.SALES_ORDER_SCHEDULE_DATE
, MFU.FORECAST_UPDATE_DATE
, MFU.SALES_ORDER_QUANTITY
, MFU.DEMAND_CLASS
, MFU.UPDATE_QUANTITY
, MFU.CUSTOMER_ID
, MFU.SHIP_ID
, MFU.BILL_ID
, MFU.LINE_NUM
, MSO.SEGMENT1 ORDER_NUMBER
, MSO.SEGMENT2 ORDER_TYPE
, MSO.SEGMENT3 ORDER_ORIGINATION
FROM MRP_FORECAST_UPDATES MFU
, MTL_SALES_ORDERS MSO
WHERE MSO.SALES_ORDER_ID = MFU.UPDATE_SALES_ORDER