eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: ONT.OE_RSV_SET_DETAILS

Object Details

Object Name:	OE_RSV_SET_DETAILS
Object Type:	TABLE
Owner:	ONT
FND Design Data:	ONT.OE_RSV_SET_DETAILS
Subobject Name:
Status:	VALID

This table is to store line information of reservation sets.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_RSV_SET_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESERVATION_SET_ID LINE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RESERVATION_SET_ID	NUMBER		Yes	Reservation set identifier
LINE_ID	NUMBER		Yes	Line identifier
HEADER_ID	NUMBER		Yes	Header id of the line
INVENTORY_ITEM_ID	NUMBER			Inventory Item Id
ORDERED_QTY	NUMBER			Quantity ordered
ORDERED_QTY_UOM	VARCHAR2	(3)		Unit of Measure of ordered quantity
DERIVED_QTY	NUMBER			Derived reservation quantity based on logic
DERIVED_QTY_UOM	VARCHAR2	(3)		Unit of Measure of derived quantity
CORRECTED_QTY	NUMBER			Derived quantity can be corrected by customer
SHIP_FROM_ORG_ID	NUMBER			Ship from organization Id (warehouse)
SUBINVENTORY	VARCHAR2	(10)		Sub-inventory
CREATION_DATE	DATE		Yes	Date of creation of this record
CREATED_BY	NUMBER		Yes	User who created this record
LAST_UPDATE_DATE	DATE		Yes	Date when this record was last updated
LAST_UPDATED_BY	NUMBER		Yes	User who last updated this record
LAST_UPDATE_LOGIN	NUMBER		Yes	Login used during last update
PROGRAM_APPLICATION_ID	NUMBER			Application of concurrent program that last updated
PROGRAM_ID	NUMBER			Concurrent program that last updated
PROGRAM_UPDATE_DATE	DATE			Last date changed by concurrent program
ORDERED_QTY2	NUMBER			Secondary Quantity
ORDERED_QTY_UOM2	VARCHAR2	(3)		UOM in secondary quantity.
DERIVED_QTY2	NUMBER			Derived quantity in secondary UOM.
CORRECTED_QTY2	NUMBER			Corrected quantity in secondary UOM.
LINE_SEQUENCE	NUMBER			sequence no of the record.

Query Text

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;

Dependencies

[top of page]

ONT.OE_RSV_SET_DETAILS does not reference any database object

ONT.OE_RSV_SET_DETAILS is referenced by following:

ONT: OE_RSV_SET_DETAILS#