DBA Data[Home] [Help] [Dependency Information]

TABLE: JTF.JTF_DIAGNOSTIC_REPORT

Object Details
Object Name: JTF_DIAGNOSTIC_REPORT
Object Type: TABLE
Owner: JTF
FND Design Data: TableJTF.JTF_DIAGNOSTIC_REPORT
Subobject Name:
Status: VALID

This table holds the individual components in a report for a test as separate entities. To construct the report for a particular execution, we can get the records for that execution_id and interpret the xmldata to construct the Report.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
SYS_IL0000445417C00005$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
JTF_DIAG_REPORT_INDEX NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXECUTION_ID
ColumnUI_NODE_ID
Columns
Name Datatype Length Mandatory Comments
EXECUTION_ID NUMBER
Yes Execution id of the test. Corresponds to the SEQUENCE column in JTF_DIAGNOSTIC_LOG table
UI_NODE_ID NUMBER
Yes Node id of this component. For every execution of a test, the node if would be unique.
TYPE VARCHAR2 (30) Yes Type of this component. There are various types of components like Message, Note, Table, Tree. This column holds this detail.
XMLDATA XMLTYPE (2000)
XML Representation of the component. Will hold the details of this component like heading, content, etc.
PARENT_NODE_ID NUMBER
Yes Holds the parent node id of this component. For eg. if the component is a row in a table, then the parent node id would be the Node id of the table to which it belongs
Query Text

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


SELECT EXECUTION_ID
,      UI_NODE_ID
,      TYPE
,      XMLDATA
,      PARENT_NODE_ID
FROM JTF.JTF_DIAGNOSTIC_REPORT;

Dependencies

[top of page]

JTF.JTF_DIAGNOSTIC_REPORT references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
JTF.JTF_DIAGNOSTIC_REPORT is referenced by following:

SchemaJTF
ViewJTF_DIAGNOSTIC_REPORT#