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: AZ.AZ_DIFF_RESULTS

Object Details

Object Name:	AZ_DIFF_RESULTS
Object Type:	TABLE
Owner:	AZ
FND Design Data:	AZ.AZ_DIFF_RESULTS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000394514C00019$$	LOB	UNIQUE	APPS_TS_TX_DATA
AZ_DIFF_RESULTS_HCD_NU2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	HASHCODE_DETAILS
AZ_DIFF_RESULTS_NU1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUEST_ID SOURCE PARENT_ID ID

Columns

Name	Datatype	Length	Mandatory	Comments
NAME	VARCHAR2	(240)		Entity Name
DISPLAY_NAME	VARCHAR2	(240)		Entity Display Name
REQUEST_ID	NUMBER	(15)	Yes	Concurrent Request ID
SOURCE	VARCHAR2	(240)	Yes	Entity Code or Split code
TYPE	NUMBER	(2)		Type Indicator for the record
ID	NUMBER		Yes	Unique Sequence for the record
PARENT_ID	NUMBER			Parent Sequence ID
HASHCODE_DETAILS	VARCHAR2	(2000)		Hash of the key attributes
DEPTH	NUMBER			Level of Hierarchy
IS_DIFFERENT	VARCHAR2	(1)		Indicates if the row is different while being compared
IS_TRANSFORMED	VARCHAR2	(1)		Indicates if the row is transformed
SHOW_ONLY_DIFF	VARCHAR2	(1)		Flag to indicate that this record would be a part of only differences in the downloadable report
PARAM1	VARCHAR2	(240)		For future use
PARAM2	VARCHAR2	(240)		For future use
PARAM3	VARCHAR2	(240)		For future use
PARAM4	VARCHAR2	(240)		For future use
PARAM5	VARCHAR2	(240)		For future use
ATTR_DIFF	XMLTYPE	(2000)
DETAIL_LOG_STATUS	VARCHAR2	(255)		Status of a load for a given row
DETAIL_LOG_MSG	VARCHAR2	(2000)		Log message of load for a given row

Query Text

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


SELECT NAME
,      DISPLAY_NAME
,      REQUEST_ID
,      SOURCE
,      TYPE
,      ID
,      PARENT_ID
,      HASHCODE_DETAILS
,      DEPTH
,      IS_DIFFERENT
,      IS_TRANSFORMED
,      SHOW_ONLY_DIFF
,      PARAM1
,      PARAM2
,      PARAM3
,      PARAM4
,      PARAM5
,      ATTR_DIFF
,      DETAIL_LOG_STATUS
,      DETAIL_LOG_MSG
FROM AZ.AZ_DIFF_RESULTS;

Dependencies

[top of page]

AZ.AZ_DIFF_RESULTS references the following:

SYS: STANDARD - show dependent code; XMLTYPE
XDB: XDJijXhYlJbEDgQBSQycRVqw==

AZ.AZ_DIFF_RESULTS is referenced by following:

APPS: AZ_DIFF_RESULTS