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_ERRORS_INT

Object Details

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

Interface Table to store the Tax Error Records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_ERRORS_INT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTF_PTP_REFERENCE REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REQUEST_ID	NUMBER	(22)	Yes	Request identifier of last concurrent program to update this record
ERROR_TABLE_NAME	VARCHAR2	(30)	Yes	The interface table for which the error is flashed
INTF_PTP_REFERENCE	VARCHAR2	(40)	Yes	User Identifier to associate to Party Tax Profile Records.
PARTY_TYPE_CODE	VARCHAR2	(30)	Yes	Column to store Lookup code for party type
MESSAGE_TEXT	VARCHAR2	(2000)	Yes	Column to store the error message.
PROG_INT_RECORD_REF	NUMBER	(22)		Unique identifier populated for the record by program internally for errored records.
PARTY_ID	NUMBER	(22)		Column to store party identifier.

Query Text

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


SELECT REQUEST_ID
,      ERROR_TABLE_NAME
,      INTF_PTP_REFERENCE
,      PARTY_TYPE_CODE
,      MESSAGE_TEXT
,      PROG_INT_RECORD_REF
,      PARTY_ID
FROM ZX.ZX_ERRORS_INT;

Dependencies

[top of page]

ZX.ZX_ERRORS_INT does not reference any database object

ZX.ZX_ERRORS_INT is referenced by following:

ZX: ZX_ERRORS_INT#