[Home] [Help]
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
Name |
RESERVATION_SET_ID |
RESERVATION_SET_NAME |
RESERVATION_REQUEST_ID |
SIMULATION_REQUEST_ID |
PROCESS_FLAG |
LINE_ID |
HEADER_ID |
INVENTORY_ITEM_ID |
ORDERED_QTY |
ORDERED_QTY_UOM |
DERIVED_QTY |
DERIVED_QTY_UOM |
CORRECTED_QTY |
SHIP_FROM_ORG_ID |
SUBINVENTORY |
ORDERED_QTY2 |
ORDERED_QTY_UOM2 |
DERIVED_QTY2 |
CORRECTED_QTY2 |