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_REASONS

Object Details

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

Table to store change reasons for entities inserted into history tables.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OE_REASONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HEADER_ID VERSION_NUMBER
OE_REASONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_CODE ENTITY_ID
OE_REASONS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ENTITY_CODE HEADER_ID LINE_ID ENTITY_ID
OE_REASONS_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REASON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REASON_ID	NUMBER		Yes	System Generated Reason Identifier
HEADER_ID	NUMBER		Yes	Foreign key reference to OE_ORDER_HEADERS_ALL; the order to which this reason belongs
ENTITY_ID	NUMBER		Yes	Foreign key reference to the entity to which this reason belongs (Used in combination with ENTITY_CODE)
ENTITY_CODE	VARCHAR2	(30)	Yes	Entity type (Header, Line, Sales Credit, Price Adj, etc) to which this reason belongs
VERSION_NUMBER	NUMBER		Yes	Version number of the entity to which this reason belongs
REASON_TYPE	VARCHAR2	(30)	Yes	Reason type of associated event
REASON_CODE	VARCHAR2	(30)		Reason code of associated event
COMMENTS	VARCHAR2	(2000)		Comments associated with reason
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
CONTEXT	VARCHAR2	(30)		Descriptive Flexfield information
ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE16	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE17	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE18	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE19	VARCHAR2	(240)		Descriptive Flexfield information
ATTRIBUTE20	VARCHAR2	(240)		Descriptive Flexfield information
LINE_ID	NUMBER			Foreign key reference to OE_ORDER_LINES_ALL

Query Text

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


SELECT REASON_ID
,      HEADER_ID
,      ENTITY_ID
,      ENTITY_CODE
,      VERSION_NUMBER
,      REASON_TYPE
,      REASON_CODE
,      COMMENTS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LINE_ID
FROM ONT.OE_REASONS;

Dependencies

[top of page]

ONT.OE_REASONS does not reference any database object

ONT.OE_REASONS is referenced by following:

ONT: OE_REASONS#