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: AX.AX_EVENT_TYPES

Object Details

Object Name:	AX_EVENT_TYPES
Object Type:	TABLE
Owner:	AX
FND Design Data:	AX.AX_EVENT_TYPES
Subobject Name:
Status:	VALID

This table stores the event types. There is a row for every event
type defined per main set of books and posting set of books.
Every row includes the set of books and the application in which the
event is defined, the event type, the translation scheme used to
translate the event, the direction of the event type (direct, reverse
or offset), the category used to generate the journal sequence and an
optional PL/SQL user exit that will be executed before translation.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: AX_EVENT_TYPES_PK

SET_OF_BOOKS_ID
APPLICATION_ID
POSTING_SET_OF_BOOKS_ID
EVENT_TYPE

Indexes

Index	Type	Uniqueness	Tablespace	Column
AX_EVENT_TYPES_U1	NORMAL	UNIQUE	APPS_TS_SEED	SET_OF_BOOKS_ID APPLICATION_ID POSTING_SET_OF_BOOKS_ID EVENT_TYPE
AX_EVENT_TYPES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	SET_OF_BOOKS_ID APPLICATION_ID TRANSLATION_SCHEME

Columns

Name	Datatype	Length	Mandatory	Comments
CATEGORY_CODE	VARCHAR2	(30)	Yes	Category code
SET_OF_BOOKS_ID	NUMBER		Yes	Set of books identifier
POSTING_SET_OF_BOOKS_ID	NUMBER		Yes	Posting set of books identifier
APPLICATION_ID	NUMBER		Yes	Application identifier
EVENT_TYPE	VARCHAR2	(30)	Yes	Event type
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
DESCRIPTION	VARCHAR2	(255)		Description
ENABLED_FLAG	VARCHAR2	(1)	Yes	Enabled flag
TRANSLATION_SCHEME	VARCHAR2	(30)	Yes	Translation scheme name
DIRECT_FLAG	VARCHAR2	(1)	Yes	Event type direction
USER_EXIT	VARCHAR2	(1996)		PL/SQL user exit code
INCLUDE_IN_PROGRAM_FLAG	VARCHAR2	(1)	Yes	Y if the event is included in the Translator Program, N otherwise

Query Text

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


SELECT CATEGORY_CODE
,      SET_OF_BOOKS_ID
,      POSTING_SET_OF_BOOKS_ID
,      APPLICATION_ID
,      EVENT_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      ENABLED_FLAG
,      TRANSLATION_SCHEME
,      DIRECT_FLAG
,      USER_EXIT
,      INCLUDE_IN_PROGRAM_FLAG
FROM AX.AX_EVENT_TYPES;

Dependencies

[top of page]

AX.AX_EVENT_TYPES does not reference any database object

AX.AX_EVENT_TYPES is referenced by following:

APPS: AX_EVENT_TYPES