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

TABLE: JTF.JTF_DIAGNOSTIC_DOWNLOAD_RPT

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

This table will hold the downloadable report which got generated for a particular request. The Report column in the table will hold the zip file of all the reports which got generated under this request name.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: REQUEST_NAME_PK
  1. ColumnREQUEST_NAME
Indexes
Index Type Uniqueness Tablespace Column
REQUEST_NAME_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_NAME
SYS_IL0000455677C00003$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
REQUEST_NAME VARCHAR2 (1000) Yes Request Name for which this downloadable report has been generated for.
REPORT_GEN_STATUS NUMBER (2) Yes Status of Report Generation
REPORT BLOB (4000)
Holds the Report which got generated. This will be a zip file containing the individual reports of every test executed under this request name.
REPORT_GEN_ERROR VARCHAR2 (4000)
Holds the Details of the error which occured during the construction of the downloadable report zip file
REPORT_REQUESTED NUMBER

Holds the detail as to whether the downloadable report has been requested for this request name.
Query Text

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


SELECT REQUEST_NAME
,      REPORT_GEN_STATUS
,      REPORT
,      REPORT_GEN_ERROR
,      REPORT_REQUESTED
FROM JTF.JTF_DIAGNOSTIC_DOWNLOAD_RPT;

Dependencies

[top of page]

JTF.JTF_DIAGNOSTIC_DOWNLOAD_RPT does not reference any database object

JTF.JTF_DIAGNOSTIC_DOWNLOAD_RPT is referenced by following:

SchemaJTF
ViewJTF_DIAGNOSTIC_DOWNLOAD_RPT#