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

TABLE: OE.SO_PURGE_ORDERS

Object Details
Object Name: SO_PURGE_ORDERS
Object Type: TABLE
Owner: OE
FND Design Data: TableOE.SO_PURGE_ORDERS
Subobject Name:
Status: VALID


SO_PURGE_ORDERS stores information about sales orders you target
for purging using the Purge Orders concurrent program. You use
information in this table to determine which orders to archive prior
to purging, and to determine (by deleting rows) which sales orders
you wish to retain.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SO_PURGE_ORDERS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
SO_PURGE_HEADERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_ID
Columns
Name Datatype Length Mandatory Comments
HEADER_ID NUMBER

Sales order to be purged
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Concurrent request that last updated row
PROGRAM_ID NUMBER

Concurrent program that last updated row
PROGRAM_APPLICATION_ID NUMBER

Application of concurrent program that last updated row
Query Text

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


SELECT HEADER_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
FROM OE.SO_PURGE_ORDERS;

Dependencies

[top of page]

OE.SO_PURGE_ORDERS does not reference any database object

OE.SO_PURGE_ORDERS is referenced by following:

SchemaAPPS
SynonymSO_PURGE_ORDERS