Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Forecast consumption transaction history view |
Implementation/DBA Data: | APPS.MRP_FORECAST_UPDATES_V |
SELECT M.ROWID ROW_ID
, M.TRANSACTION_ID
, M.LAST_UPDATE_DATE
, M.LAST_UPDATED_BY
, M.CREATION_DATE
, M.CREATED_BY
, M.LAST_UPDATE_LOGIN
, M.INVENTORY_ITEM_ID
, M.ORGANIZATION_ID
, M.FORECAST_DESIGNATOR
, M.UPDATE_SALES_ORDER
, M.SALES_ORDER_SCHEDULE_DATE
, M.FORECAST_UPDATE_DATE
, M.SALES_ORDER_QUANTITY
, M.DEMAND_CLASS
, M.UPDATE_QUANTITY
, MSOU.INVENTORY_ITEM_ID SALES_ORDER_ITEM_ID
, DEM.INVENTORY_ITEM_ID SALES_ORDER_ITEM_ID2
, M.CUSTOMER_ID
, CUST.CUSTOMER_NAME
, M.SHIP_ID
, SHIP.ADDRESS1 SHIP_ADDRESS
, M.BILL_ID
, BILL.ADDRESS1 BILL_ADDRESS
, M.LINE_NUM
, M.REQUEST_ID
, M.PROGRAM_APPLICATION_ID
, M.PROGRAM_ID
, M.PROGRAM_UPDATE_DATE
FROM MRP_FORECAST_UPDATES M
, MRP_SALES_ORDER_UPDATES MSOU
, OE_ORDER_LINES_ALL DEM
, RA_CUSTOMERS_VIEW CUST
, RA_SITE_USES SU1
, RA_SITE_USES SU2
, RA_ADDRESSES SHIP
, RA_ADDRESSES BILL
WHERE M.CUSTOMER_ID = CUST.CUSTOMER_ID(+)
AND M.SHIP_ID = SU1.SITE_USE_ID(+)
AND SHIP.ADDRESS_ID(+) = SU1.ADDRESS_ID
AND SU1.SITE_USE_CODE(+) = 'SHIP_TO'
AND M.BILL_ID = SU2.SITE_USE_ID(+)
AND BILL.ADDRESS_ID(+) = SU2.ADDRESS_ID
AND SU2.SITE_USE_CODE(+) = 'BILL_TO'
AND M.UPDATE_SEQ_NUM = MSOU.SALES_ORDER_ID
AND M.UPDATE_SEQ_NUM = DEM.LINE_ID