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_REPORT_CODES_ASSOC_INT

Object Details

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

Interface Table to store the Reporting Code Association Records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_REPORT_CODES_ASSOC_INT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTF_PTP_REFERENCE

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(22)		Identifier to identify a set of records to be processed as a batch.
REQUEST_ID	NUMBER	(22)		Request identifier of last concurrent program to update this record
INTF_PTP_REFERENCE	VARCHAR2	(40)	Yes	User Identifier to associate to the corresponding Party Tax Profile
DML_TYPE	VARCHAR2	(10)	Yes	Indicates whether the record is for insert or for update.
RECORD_STATUS	NUMBER	(2)		Interface record status
ERROR_NUMBER	NUMBER	(22)		For program internal use only This column is used to store the error number whenever an error is flashed
PARTY_TAX_PROFILE_ID	NUMBER	(22)		Party Tax Profile identifier
PROG_INT_RECORD_REF	NUMBER	(22)		Unique identifier populated for the record in context of batch being processed by program internally for errored records.
PROG_INT_CHAR1	VARCHAR2	(30)		For program internal use only
PROG_INT_NUM1	NUMBER	(22)		For program internal use only
REPORTING_CODE_ASSOC_ID	NUMBER	(22)		Unique identifier
ENTITY_CODE	VARCHAR2	(30)	Yes	Lookup code to identify the entity with which the reporting code is associated
ENTITY_ID	NUMBER	(22)		Entity identifier
EFFECTIVE_FROM	DATE		Yes	Effective from date
EFFECTIVE_TO	DATE			Effective to date
REPORTING_TYPE_ID	NUMBER	(22)		Reporting type identifier
REPORTING_TYPE_NAME	VARCHAR2	(240)		Reporting type identifier
REPORTING_CODE_ID	NUMBER	(22)		Reporting code identifier
REPORTING_CODE_NAME	VARCHAR2	(240)		Reporting code identifier
REPORTING_CODE_CHAR_VALUE	VARCHAR2	(60)		Column to store alphanumeric value for the reporting code
REPORTING_CODE_DATE_VALUE	DATE			Column to store date value for the reporting code
REPORTING_CODE_NUM_VALUE	NUMBER	(22)		Column to store numeric value for the reporting code

Query Text

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


SELECT BATCH_ID
,      REQUEST_ID
,      INTF_PTP_REFERENCE
,      DML_TYPE
,      RECORD_STATUS
,      ERROR_NUMBER
,      PARTY_TAX_PROFILE_ID
,      PROG_INT_RECORD_REF
,      PROG_INT_CHAR1
,      PROG_INT_NUM1
,      REPORTING_CODE_ASSOC_ID
,      ENTITY_CODE
,      ENTITY_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      REPORTING_TYPE_ID
,      REPORTING_TYPE_NAME
,      REPORTING_CODE_ID
,      REPORTING_CODE_NAME
,      REPORTING_CODE_CHAR_VALUE
,      REPORTING_CODE_DATE_VALUE
,      REPORTING_CODE_NUM_VALUE
FROM ZX.ZX_REPORT_CODES_ASSOC_INT;

Dependencies

[top of page]

ZX.ZX_REPORT_CODES_ASSOC_INT does not reference any database object

ZX.ZX_REPORT_CODES_ASSOC_INT is referenced by following:

ZX: ZX_REPORT_CODES_ASSOC_INT#