VIEW: APPS.WIP_RESERVATIONS_V

Source

View Text - Preformatted

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 */

View Text - HTML Formatted

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 */