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_PURGE_ORDERS

Object Details

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

OE_PURGE_ORDERS stores the order details for orders included in a purge set.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_PURGE_ORDERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PURGE_SET_ID HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PURGE_SET_ID	NUMBER		Yes	Unique Key
HEADER_ID	NUMBER		Yes	Header id for the Order
ORDER_NUMBER	NUMBER			Order Number
ORDER_TYPE_NAME	VARCHAR2	(30)		Order Type Name for the Order
CUSTOMER_NUMBER	NUMBER			Customer number of the order
PRICE_LIST_ID	NUMBER			Price list Identification for the order
IS_PURGABLE	VARCHAR2	(1)		Flag to indicate whether the order is purgable
IS_PURGED	VARCHAR2	(1)		Flag to indicate whether the order has been purged
ERROR_TEXT	VARCHAR2	(2000)		Error message text. This will be populated if any errors occured for the order
REQUEST_ID	NUMBER			Request Id for the concurrent request processing the order
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGON	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Application of concurrent program which last updated row
PROGRAM_ID	NUMBER			Concurrent program that last updated row
PROGRAM_UPDATE_DATE	DATE			Last date changed by concurrent program
QUOTE_NUMBER	NUMBER			Quote Number to be Purged
FLOW_STATUS	VARCHAR2	(80)		Order Flow Status
EXPIRATION_DATE	DATE			Quote Expires On
UPGRADED_FLAG	VARCHAR2	(1)		Upgraded Flag

Query Text

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


SELECT PURGE_SET_ID
,      HEADER_ID
,      ORDER_NUMBER
,      ORDER_TYPE_NAME
,      CUSTOMER_NUMBER
,      PRICE_LIST_ID
,      IS_PURGABLE
,      IS_PURGED
,      ERROR_TEXT
,      REQUEST_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGON
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      QUOTE_NUMBER
,      FLOW_STATUS
,      EXPIRATION_DATE
,      UPGRADED_FLAG
FROM ONT.OE_PURGE_ORDERS;

Dependencies

[top of page]

ONT.OE_PURGE_ORDERS does not reference any database object

ONT.OE_PURGE_ORDERS is referenced by following:

APPS: OE_PURGE_ORDERS