[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZX_ERRORS_INT_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INTF_PTP_REFERENCE
REQUEST_ID |
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. |
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;
ZX.ZX_ERRORS_INT does not reference any database object
ZX.ZX_ERRORS_INT is referenced by following:
|
|
|