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: ZX.ZX_EVNT_CLS_OPTIONS

Object Details

Object Name:	ZX_EVNT_CLS_OPTIONS
Object Type:	TABLE
Owner:	ZX
FND Design Data:	ZX.ZX_EVNT_CLS_OPTIONS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_EVNT_CLS_OPTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_CLASS_OPTIONS_ID
ZX_EVNT_CLS_OPTIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID ENTITY_CODE EVENT_CLASS_CODE FIRST_PTY_ORG_ID EFFECTIVE_FROM ENABLED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_CLASS_OPTIONS_ID	NUMBER	(15)	Yes	Unique identifier
EVENT_CLASS_CODE	VARCHAR2	(30)	Yes	Application event class code
APPLICATION_ID	NUMBER		Yes	Application identifier
ENTITY_CODE	VARCHAR2	(30)	Yes	Entity code for the application event class
DET_FACTOR_TEMPL_CODE	VARCHAR2	(30)	Yes	Determining factor template to be used for tax regime determination for this event class
DEFAULT_ROUNDING_LEVEL_CODE	VARCHAR2	(30)	Yes	Lookup code to indicate the default level of rounding for this event class. Possible values are LINE and HEADER.
ROUNDING_LEVEL_HIER_1_CODE	VARCHAR2	(30)		Lookup code to indicate the first precedence for level of rounding for this event class
ROUNDING_LEVEL_HIER_2_CODE	VARCHAR2	(30)		Lookup code to indicate the second precedence for level of rounding for this event class
ROUNDING_LEVEL_HIER_3_CODE	VARCHAR2	(30)		Lookup code to indicate the third precedence for level of rounding for this event class
ROUNDING_LEVEL_HIER_4_CODE	VARCHAR2	(30)		Lookup code to indicate the fourth precedence for level of rounding for this event class
ALLOW_MANUAL_LIN_RECALC_FLAG	VARCHAR2	(1)	Yes	Y or N indicates if the tax is recalculated for manually entered tax lines of this event class
ALLOW_OVERRIDE_FLAG	VARCHAR2	(1)	Yes	Y or N indicates if the user is allowed to override tax calculated by the system for this event class
ALLOW_MANUAL_LINES_FLAG	VARCHAR2	(1)	Yes	Y or N indicates if the user is allowed to manually eneter tax lines for this event class
PERF_ADDNL_APPL_FOR_IMPRT_FLAG	VARCHAR2	(1)	Yes	Y or N indicates if additional applicability is performed for imported documents of this event class
EFFECTIVE_FROM	DATE		Yes	Effective from date
EFFECTIVE_TO	DATE			Effective to date
ENABLED_FLAG	VARCHAR2	(1)	Yes	Y or N indicates if the tax options setup is enabled for this event class and first party organization
FIRST_PTY_ORG_ID	NUMBER	(15)	Yes	Party tax profile identifier for first party organization
ENFORCE_TAX_FROM_ACCT_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether the tax associated with the natural account segment is enforced for this event class
OFFSET_TAX_BASIS_CODE	VARCHAR2	(30)		Lookup code for tax basis used in offset tax calculation for this event class
TAX_TOLERANCE	NUMBER			Tax tolerance percentage for this event class
TAX_TOL_AMT_RANGE	NUMBER			Tax tolerance range amount for this event class
RECORD_TYPE_CODE	VARCHAR2	(30)	Yes	Lookup code to indicate whether the record is migrated, seeded or defined by the user
ALLOW_OFFSET_TAX_CALC_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether offset taxes are determined for this event class. This is applicable only if this event class belongs to the procure to pay product family
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ENTER_OVRD_INCL_TAX_LINES_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether the user is allowed to enter or override inclusive tax lines for this event class
CTRL_EFF_OVRD_CALC_LINES_FLAG	VARCHAR2	(1)	Yes	Y or N indicates if all impacted system tax lines are recalculated for this event class, when there is an override on a inclusive tax line
PROCESS_FOR_APPLICABILITY_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether taxes should be automatically calculated for this event class or not
ENFORCE_TAX_FROM_REF_DOC_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether this event class checks that tax name on the event class line is same as tax name on the corresponding reference document line.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
ALLOW_EXEMPTIONS_FLAG	VARCHAR2	(1)		Y or N indicates whether exemptions are allowed for this event class
EXMPTN_PTY_BASIS_HIER_1_CODE	VARCHAR2	(30)		Lookup code to indicate the first level of exemption party basis hierarchy for this event class
EXMPTN_PTY_BASIS_HIER_2_CODE	VARCHAR2	(30)		Lookup code to indicate the second level of exemption party basis hierarchy for this event class
DEF_INTRCMP_TRX_BIZ_CATEGORY	VARCHAR2	(240)		Default intercompany transaction business category code for this event class

Query Text

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


SELECT EVENT_CLASS_OPTIONS_ID
,      EVENT_CLASS_CODE
,      APPLICATION_ID
,      ENTITY_CODE
,      DET_FACTOR_TEMPL_CODE
,      DEFAULT_ROUNDING_LEVEL_CODE
,      ROUNDING_LEVEL_HIER_1_CODE
,      ROUNDING_LEVEL_HIER_2_CODE
,      ROUNDING_LEVEL_HIER_3_CODE
,      ROUNDING_LEVEL_HIER_4_CODE
,      ALLOW_MANUAL_LIN_RECALC_FLAG
,      ALLOW_OVERRIDE_FLAG
,      ALLOW_MANUAL_LINES_FLAG
,      PERF_ADDNL_APPL_FOR_IMPRT_FLAG
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      ENABLED_FLAG
,      FIRST_PTY_ORG_ID
,      ENFORCE_TAX_FROM_ACCT_FLAG
,      OFFSET_TAX_BASIS_CODE
,      TAX_TOLERANCE
,      TAX_TOL_AMT_RANGE
,      RECORD_TYPE_CODE
,      ALLOW_OFFSET_TAX_CALC_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ENTER_OVRD_INCL_TAX_LINES_FLAG
,      CTRL_EFF_OVRD_CALC_LINES_FLAG
,      PROCESS_FOR_APPLICABILITY_FLAG
,      ENFORCE_TAX_FROM_REF_DOC_FLAG
,      OBJECT_VERSION_NUMBER
,      ALLOW_EXEMPTIONS_FLAG
,      EXMPTN_PTY_BASIS_HIER_1_CODE
,      EXMPTN_PTY_BASIS_HIER_2_CODE
,      DEF_INTRCMP_TRX_BIZ_CATEGORY
FROM ZX.ZX_EVNT_CLS_OPTIONS;

Dependencies

[top of page]

ZX.ZX_EVNT_CLS_OPTIONS does not reference any database object

ZX.ZX_EVNT_CLS_OPTIONS is referenced by following:

APPS: ZX_EVNT_CLS_OPTIONS