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]

VIEW: ZX.ZX_REPORT_CODES_ASSOC_INT#

Object Details

Object Name:	ZX_REPORT_CODES_ASSOC_INT#
Object Type:	VIEW
Owner:	ZX
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
BATCH_ID	NUMBER	(22)
REQUEST_ID	NUMBER	(22)
INTF_PTP_REFERENCE	VARCHAR2	(40)	Yes
DML_TYPE	VARCHAR2	(10)	Yes
RECORD_STATUS	NUMBER	(2)
ERROR_NUMBER	NUMBER	(22)
PARTY_TAX_PROFILE_ID	NUMBER	(22)
PROG_INT_RECORD_REF	NUMBER	(22)
PROG_INT_CHAR1	VARCHAR2	(30)
PROG_INT_NUM1	NUMBER	(22)
REPORTING_CODE_ASSOC_ID	NUMBER	(22)
ENTITY_CODE	VARCHAR2	(30)	Yes
ENTITY_ID	NUMBER	(22)
EFFECTIVE_FROM	DATE		Yes
EFFECTIVE_TO	DATE
REPORTING_TYPE_ID	NUMBER	(22)
REPORTING_TYPE_NAME	VARCHAR2	(240)
REPORTING_CODE_ID	NUMBER	(22)
REPORTING_CODE_NAME	VARCHAR2	(240)
REPORTING_CODE_CHAR_VALUE	VARCHAR2	(60)
REPORTING_CODE_DATE_VALUE	DATE
REPORTING_CODE_NUM_VALUE	NUMBER	(22)

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# references the following:

ZX: ZX_REPORT_CODES_ASSOC_INT

ZX.ZX_REPORT_CODES_ASSOC_INT# is referenced by following:

APPS: ZX_REPORT_CODES_ASSOC_INT