View: OE_RESERVATION_SETS_V

Product:	ONT - Order Management
Description:	View for Reservation set information
Implementation/DBA Data:	APPS.OE_RESERVATION_SETS_V

View Text

SELECT RSET.RESERVATION_SET_ID
, RSET.RESERVATION_SET_NAME
, RSET.RESERVATION_REQUEST_ID
, RSET.SIMULATION_REQUEST_ID
, RSET.PROCESS_FLAG
, RALL.LINE_ID
, RALL.HEADER_ID
, RALL.INVENTORY_ITEM_ID
, RALL.ORDERED_QTY
, RALL.ORDERED_QTY_UOM
, RALL.DERIVED_QTY
, RALL.DERIVED_QTY_UOM
, RALL.CORRECTED_QTY
, RALL.SHIP_FROM_ORG_ID
, RALL.SUBINVENTORY
, RALL.ORDERED_QTY2
, RALL.ORDERED_QTY_UOM2
, RALL.DERIVED_QTY2
, RALL.CORRECTED_QTY2 RALL
FROM OE_RESERVATION_SETS RSET
, OE_RSV_SET_DETAILS RALL
WHERE RSET.RESERVATION_SET_ID = RALL.RESERVATION_SET_ID

Columns