VIEW: APPS.MRP_FORECAST_UPDATES_V

Source

View Text - Preformatted

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 , CUST1.PARTY_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, HZ_CUST_ACCOUNTS CUST, HZ_CUST_ACCT_SITES AS1, HZ_CUST_ACCT_SITES AS2, HZ_CUST_SITE_USES SU1, HZ_CUST_SITE_USES SU2, HZ_PARTIES CUST1, HZ_PARTY_SITES PS1, HZ_PARTY_SITES PS2, HZ_LOCATIONS SHIP, HZ_LOCATIONS BILL WHERE M.CUSTOMER_ID = CUST.CUST_ACCOUNT_ID(+) AND CUST1.PARTY_ID = CUST.PARTY_ID AND M.SHIP_ID = SU1.SITE_USE_ID(+) AND SU1.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID(+) AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID(+) AND PS1.LOCATION_ID = SHIP.LOCATION_ID(+) AND SU1.SITE_USE_CODE(+) = 'SHIP_TO' AND M.BILL_ID = SU2.SITE_USE_ID(+) AND SU2.CUST_ACCT_SITE_ID = AS2.CUST_ACCT_SITE_ID(+) AND AS2.PARTY_SITE_ID = PS2.PARTY_SITE_ID (+) AND PS2.LOCATION_ID = BILL.LOCATION_ID (+) AND SU2.SITE_USE_CODE(+) = 'BILL_TO' AND M.UPDATE_SEQ_NUM = MSOU.SALES_ORDER_ID(+) AND M.ORGANIZATION_ID = MSOU.ORGANIZATION_ID(+) AND M.INVENTORY_ITEM_ID = MSOU.INVENTORY_ITEM_ID(+) AND M.UPDATE_SEQ_NUM = DEM.LINE_ID (+)

View Text - HTML Formatted

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
, CUST1.PARTY_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
, HZ_CUST_ACCOUNTS CUST
, HZ_CUST_ACCT_SITES AS1
, HZ_CUST_ACCT_SITES AS2
, HZ_CUST_SITE_USES SU1
, HZ_CUST_SITE_USES SU2
, HZ_PARTIES CUST1
, HZ_PARTY_SITES PS1
, HZ_PARTY_SITES PS2
, HZ_LOCATIONS SHIP
, HZ_LOCATIONS BILL
WHERE M.CUSTOMER_ID = CUST.CUST_ACCOUNT_ID(+)
AND CUST1.PARTY_ID = CUST.PARTY_ID
AND M.SHIP_ID = SU1.SITE_USE_ID(+)
AND SU1.CUST_ACCT_SITE_ID = AS1.CUST_ACCT_SITE_ID(+)
AND AS1.PARTY_SITE_ID = PS1.PARTY_SITE_ID(+)
AND PS1.LOCATION_ID = SHIP.LOCATION_ID(+)
AND SU1.SITE_USE_CODE(+) = 'SHIP_TO'
AND M.BILL_ID = SU2.SITE_USE_ID(+)
AND SU2.CUST_ACCT_SITE_ID = AS2.CUST_ACCT_SITE_ID(+)
AND AS2.PARTY_SITE_ID = PS2.PARTY_SITE_ID (+)
AND PS2.LOCATION_ID = BILL.LOCATION_ID (+)
AND SU2.SITE_USE_CODE(+) = 'BILL_TO'
AND M.UPDATE_SEQ_NUM = MSOU.SALES_ORDER_ID(+)
AND M.ORGANIZATION_ID = MSOU.ORGANIZATION_ID(+)
AND M.INVENTORY_ITEM_ID = MSOU.INVENTORY_ITEM_ID(+)
AND M.UPDATE_SEQ_NUM = DEM.LINE_ID (+)