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_PROCESS_RESULTS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_PROCESS_RESULTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	RESULT_ID
ZX_PROCESS_RESULTS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TAX_RULE_ID CONDITION_GROUP_CODE ENABLED_FLAG PRIORITY TAX_STATUS_CODE CONDITION_SET_ID EXCEPTION_SET_ID
ZX_PROCESS_RESULTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONDITION_GROUP_CODE ENABLED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
CONDITION_GROUP_CODE	VARCHAR2	(50)	Yes	Condition group code for which this process result is defined
PRIORITY	NUMBER		Yes	Priority order for this process result in which the condition groups using the same determining factor template are evaluated to obtain this result
RESULT_TYPE_CODE	VARCHAR2	(30)	Yes	Lookup code to indicates the type of this process result
TAX_STATUS_CODE	VARCHAR2	(30)		Tax status code for this process result
NUMERIC_RESULT	NUMBER			Column to store the numeric result value for this process result
ALPHANUMERIC_RESULT	VARCHAR2	(150)		Column to store the alphanumeric result value for this process result
STATUS_RESULT	VARCHAR2	(150)		Tax status code pointed by this process result when the condition group evaluates to be true
RATE_RESULT	VARCHAR2	(150)		Tax rate code pointed by this process result when the condition group evaluates to be true
LEGAL_MESSAGE_CODE	VARCHAR2	(30)		Legal mnessage code pointed by this process result when the condition group evaluates to be true
MIN_TAX_AMT	NUMBER			Minimum threshold for tax amount pointed by this process result when the condition group evaluates to be true
MAX_TAX_AMT	NUMBER			Maximum threshold for tax amount pointed by this process result when the condition group evaluates to be true
MIN_TAXABLE_BASIS	NUMBER			Minimum threshold for taxable basis pointed by this process result when the condition group evaluates to be true
MAX_TAXABLE_BASIS	NUMBER			Maximum threshold for taxable basis pointed by this process result when the condition group evaluates to be true
MIN_TAX_RATE	NUMBER			Minimum threshold for tax rate pointed by this process result when the condition group evaluates to be true
MAX_TAX_RATE	NUMBER			Maximum threshold for tax rate pointed by this process result when the condition group evaluates to be true
ENABLED_FLAG	VARCHAR2	(1)	Yes	Y or N indicates if this process result is enabled
ALLOW_EXEMPTIONS_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether exemptions are applicable for this process result
ALLOW_EXCEPTIONS_FLAG	VARCHAR2	(1)	Yes	Y or N indicates whether exceptions are applicable for this process result
RECORD_TYPE_CODE	VARCHAR2	(30)	Yes	Lookup code to indicate whether the record is migrated, seeded or defined by the user
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER			Program identifier of last concurrent program to update this record
CONDITION_SET_ID	NUMBER	(15)		Condition set identifier for this process result
EXCEPTION_SET_ID	NUMBER	(15)		Exception set identifier for this process result
PROGRAM_LOGIN_ID	NUMBER			Login user identifier of last concurrent program to update this record
RESULT_ID	NUMBER	(15)	Yes	Unique identifier
CONTENT_OWNER_ID	NUMBER	(15)	Yes	Party tax profile identifier for configuration owner of this process result
CONDITION_GROUP_ID	NUMBER	(15)	Yes	Condition group identifier for which this process result is defined
TAX_RULE_ID	NUMBER	(15)	Yes	Tax rule identifier for which this process result is defined
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
RESULT_API	VARCHAR2	(2000)		API pointed by this process result when the condition group evaluates to be true
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object version number

Query Text

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


SELECT CONDITION_GROUP_CODE
,      PRIORITY
,      RESULT_TYPE_CODE
,      TAX_STATUS_CODE
,      NUMERIC_RESULT
,      ALPHANUMERIC_RESULT
,      STATUS_RESULT
,      RATE_RESULT
,      LEGAL_MESSAGE_CODE
,      MIN_TAX_AMT
,      MAX_TAX_AMT
,      MIN_TAXABLE_BASIS
,      MAX_TAXABLE_BASIS
,      MIN_TAX_RATE
,      MAX_TAX_RATE
,      ENABLED_FLAG
,      ALLOW_EXEMPTIONS_FLAG
,      ALLOW_EXCEPTIONS_FLAG
,      RECORD_TYPE_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      CONDITION_SET_ID
,      EXCEPTION_SET_ID
,      PROGRAM_LOGIN_ID
,      RESULT_ID
,      CONTENT_OWNER_ID
,      CONDITION_GROUP_ID
,      TAX_RULE_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RESULT_API
,      OBJECT_VERSION_NUMBER
FROM ZX.ZX_PROCESS_RESULTS;

Dependencies

[top of page]

ZX.ZX_PROCESS_RESULTS does not reference any database object

ZX.ZX_PROCESS_RESULTS is referenced by following:

APPS: ZX_PROCESS_RESULTS