View: WIP_RESERVATIONS_V

Product:	WIP - Work in Process
Description:	This view is used to select reservations to WIP Discrete Jobs or WIP Flow Schedules.
Implementation/DBA Data:	APPS.WIP_RESERVATIONS_V

View Text

SELECT MR.ROWID
, MR.RESERVATION_ID
, MR.ORGANIZATION_ID
, MR.DEMAND_SOURCE_TYPE_ID
, MR.DEMAND_SOURCE_NAME
, MR.DEMAND_SOURCE_HEADER_ID
, MR.DEMAND_SOURCE_LINE_ID
, OOL.LINE_NUMBER
, MSO.SEGMENT1
, MSO.SEGMENT2
, /* 10 */ MSO.SEGMENT3
, OOL.DEMAND_CLASS_CODE
, MR.REQUIREMENT_DATE
, MR.INVENTORY_ITEM_ID
, MR.REVISION
, MR.SUBINVENTORY_CODE
, MR.LOCATOR_ID
, MR.LOT_NUMBER
, MR.SERIAL_NUMBER
, MR.PRIMARY_UOM_CODE
, /* 20 */ MR.PRIMARY_RESERVATION_QUANTITY
, MR.RESERVATION_UOM_CODE
, MR.RESERVATION_QUANTITY
, OOL.ORDER_QUANTITY_UOM
, INV_CONVERT.INV_UM_CONVERT(MR.INVENTORY_ITEM_ID
, 6
, MR.PRIMARY_RESERVATION_QUANTITY
, MR.PRIMARY_UOM_CODE
, OOL.ORDER_QUANTITY_UOM
, NULL
, NULL)
, MR.SUPPLY_SOURCE_HEADER_ID
, MR.LAST_UPDATE_DATE
, MR.LAST_UPDATED_BY
, MR.CREATION_DATE
, MR.CREATED_BY
, /* 30 */ MR.LAST_UPDATE_LOGIN
, MR.REQUEST_ID
, MR.PROGRAM_APPLICATION_ID
, MR.PROGRAM_ID
, MR.PROGRAM_UPDATE_DATE /* 35 */
FROM MTL_RESERVATIONS MR
, OE_ORDER_LINES_ALL OOL
, MTL_SALES_ORDERS MSO
WHERE MSO.SALES_ORDER_ID = MR.DEMAND_SOURCE_HEADER_ID
AND MR.DEMAND_SOURCE_LINE_ID = OOL.LINE_ID
AND MR.DEMAND_SOURCE_TYPE_ID IN ( 2
, 8) /* INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE */
AND MR.SUPPLY_SOURCE_TYPE_ID = 5 /* INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_WIP */

Columns