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: OKL.OKL_ACC_EVENTS_ALL

Object Details

Object Name:	OKL_ACC_EVENTS_ALL
Object Type:	TABLE
Owner:	OKL
FND Design Data:	OKL.OKL_ACC_EVENTS_ALL
Subobject Name:
Status:	VALID

An event is an entity whose role is to map transaction data to the accounting created for it. Every accounting entry needs to be identified with the event that created it. Conceptually, an event provides information about the timing and the reason for which the document created the accounting entries. Every event will result in one, and only one, accounting entry header in each set of books. Also, transaction data is stamped with the event that accounted for it.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OKL_ACC_EVENTS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID
OKL_ACC_EVENTS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_TYPE_CODE
OKL_ACC_EVENTS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
OKL_ACC_EVENTS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_ID SOURCE_TABLE
OKL_ACC_EVENTS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SOURCE_TABLE

Columns

Name	Datatype	Length	Mandatory	Comments
ACCOUNTING_EVENT_ID	NUMBER		Yes	Accounting event identifier
EVENT_NUMBER	NUMBER	(15)	Yes	Accounting event number. The event number acts as a sequence for a given transaction
EVENT_TYPE_CODE	VARCHAR2	(30)	Yes	Type of event. Points to FND lookup OKL_ACCOUNTING_EVENT_TYPE
SOURCE_ID	NUMBER		Yes	Primary key value for transaction, which originated this event
EVENT_STATUS_CODE	VARCHAR2	(90)	Yes	Indicates the status of the accounting entries for the accounting event. Points to FND lookup OKL_ACCOUNTING_EVENT_STATUS
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	Column used for locking records during updates
ACCOUNTING_DATE	DATE		Yes	Accounting date for accounting entries of the event
SOURCE_TABLE	VARCHAR2	(90)	Yes	Table where the transaction record, which originated this event, resides. Some of the values are OKL_TXL_CNTRCT_LNS, OKL_TXL_ASSETS_B etc. Points to OKL_SOURCE_TABLE
ORG_ID	NUMBER			Operating unit identifier
PROGRAM_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Manager column
PROGRAM_UPDATE_DATE	DATE			Concurrent Manager column
REQUEST_ID	NUMBER	(15)		Concurrent Manager column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

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


SELECT ACCOUNTING_EVENT_ID
,      EVENT_NUMBER
,      EVENT_TYPE_CODE
,      SOURCE_ID
,      EVENT_STATUS_CODE
,      OBJECT_VERSION_NUMBER
,      ACCOUNTING_DATE
,      SOURCE_TABLE
,      ORG_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM OKL.OKL_ACC_EVENTS_ALL;

Dependencies

[top of page]

OKL.OKL_ACC_EVENTS_ALL does not reference any database object

OKL.OKL_ACC_EVENTS_ALL is referenced by following:

OKL: OKL_ACC_EVENTS_ALL#