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_SELECTED_ITEMS

Object Details

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

Stores the inventory items selected by users in the Advance Item Search Window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_SELECTED_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SESSION_ID

Columns

Name	Datatype	Length	Comments
SESSION_ID	NUMBER		Contains the session id, a sequence generated number to identify the inventory items selected by a user.
INVENTORY_ITEM_ID	NUMBER		Contains the ID Of the inventory items choosen in the Advanced Item Search Window.
USED_FLAG	VARCHAR2	(1)	Indicates whether the selected item has been processed by Order Management API.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SESSION_ID
,      INVENTORY_ITEM_ID
,      USED_FLAG
FROM ONT.OE_SELECTED_ITEMS;

Dependencies

[top of page]

ONT.OE_SELECTED_ITEMS does not reference any database object

ONT.OE_SELECTED_ITEMS is referenced by following:

APPS: OE_SELECTED_ITEMS