[Home] [Help] [Dependency Information]
Object Name: | OE_RSV_SET_DETAILS# |
---|---|
Object Type: | VIEW |
Owner: | ONT |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESERVATION_SET_ID | NUMBER | Yes | ||
LINE_ID | NUMBER | Yes | ||
HEADER_ID | NUMBER | Yes | ||
INVENTORY_ITEM_ID | NUMBER | |||
ORDERED_QTY | NUMBER | |||
ORDERED_QTY_UOM | VARCHAR2 | (3) | ||
DERIVED_QTY | NUMBER | |||
DERIVED_QTY_UOM | VARCHAR2 | (3) | ||
CORRECTED_QTY | NUMBER | |||
SHIP_FROM_ORG_ID | NUMBER | |||
SUBINVENTORY | VARCHAR2 | (10) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | Yes | ||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
ORDERED_QTY2 | NUMBER | |||
ORDERED_QTY_UOM2 | VARCHAR2 | (3) | ||
DERIVED_QTY2 | NUMBER | |||
CORRECTED_QTY2 | NUMBER | |||
LINE_SEQUENCE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RESERVATION_SET_ID
, LINE_ID
, HEADER_ID
, INVENTORY_ITEM_ID
, ORDERED_QTY
, ORDERED_QTY_UOM
, DERIVED_QTY
, DERIVED_QTY_UOM
, CORRECTED_QTY
, SHIP_FROM_ORG_ID
, SUBINVENTORY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORDERED_QTY2
, ORDERED_QTY_UOM2
, DERIVED_QTY2
, CORRECTED_QTY2
, LINE_SEQUENCE
FROM ONT.OE_RSV_SET_DETAILS#;
|
|
|