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: HRI.HRI_ADM_DGNSTC_SETUP

Object Details

Object Name:	HRI_ADM_DGNSTC_SETUP
Object Type:	TABLE
Owner:	HRI
Subobject Name:
Status:	VALID

This table stores the metadata required for running the setup diagnostics reports.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HRI_ADM_DGNSTC_SETUP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_NAME OBJECT_TYPE

Columns

Name	Datatype	Length	Comments
OBJECT_NAME	VARCHAR2	(80)
OBJECT_TYPE	VARCHAR2	(30)
DYNAMIC_SQL	VARCHAR2	(4000)
EXCEPTION_STATUS_MSG_CD	VARCHAR2	(30)
VALID_STATUS_MSG_CD	VARCHAR2	(30)
EXCEPTION_VALUE	VARCHAR2	(30)
IMPACT_MSG_NAME	VARCHAR2	(30)
ADD_INFO_URL	VARCHAR2	(200)
ENABLED_FLAG	VARCHAR2	(30)
FOUNDATION_HR_FLAG	VARCHAR2	(30)
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
NULL_IMPACT_MSG_NAME	VARCHAR2	(30)
COL_HEADING1	VARCHAR2	(100)
COL_HEADING2	VARCHAR2	(100)
COL_HEADING3	VARCHAR2	(100)
COL_HEADING4	VARCHAR2	(100)
COL_HEADING5	VARCHAR2	(100)
OBJECT_TYPE_DESC	VARCHAR2	(100)	Stores the message code for section description in count mode
OBJECT_NAME_DESC	VARCHAR2	(100)	Stores the message code for subsection description in count mode
DEFAULT_MODE	VARCHAR2	(30)
REPORT_TYPE	VARCHAR2	(30)
SEQ_NUM	NUMBER
COUNT_HEADING	VARCHAR2	(100)
OBJECT_TYPE_MSG_NAME	VARCHAR2	(30)	Stores the message code for section title
OBJECT_NAME_MSG_NAME	VARCHAR2	(30)	Stores the message code for subsection title
OBJECT_TYPE_DTL_DESC_MSG_NAME	VARCHAR2	(30)	Stores the message code for section description in detail mode
OBJECT_NAME_DTL_DESC_MSG_NAME	VARCHAR2	(30)	Stores the message code for subsection description in detail mode
FUNCTIONAL_AREA_CD	VARCHAR2	(30)
DYNAMIC_SQL_TYPE	VARCHAR2	(30)

Query Text

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


SELECT OBJECT_NAME
,      OBJECT_TYPE
,      DYNAMIC_SQL
,      EXCEPTION_STATUS_MSG_CD
,      VALID_STATUS_MSG_CD
,      EXCEPTION_VALUE
,      IMPACT_MSG_NAME
,      ADD_INFO_URL
,      ENABLED_FLAG
,      FOUNDATION_HR_FLAG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      NULL_IMPACT_MSG_NAME
,      COL_HEADING1
,      COL_HEADING2
,      COL_HEADING3
,      COL_HEADING4
,      COL_HEADING5
,      OBJECT_TYPE_DESC
,      OBJECT_NAME_DESC
,      DEFAULT_MODE
,      REPORT_TYPE
,      SEQ_NUM
,      COUNT_HEADING
,      OBJECT_TYPE_MSG_NAME
,      OBJECT_NAME_MSG_NAME
,      OBJECT_TYPE_DTL_DESC_MSG_NAME
,      OBJECT_NAME_DTL_DESC_MSG_NAME
,      FUNCTIONAL_AREA_CD
,      DYNAMIC_SQL_TYPE
FROM HRI.HRI_ADM_DGNSTC_SETUP;

Dependencies

[top of page]

HRI.HRI_ADM_DGNSTC_SETUP does not reference any database object

HRI.HRI_ADM_DGNSTC_SETUP is referenced by following:

APPS: HRI_ADM_DGNSTC_SETUP; HRI_ADM_DGNSTC_SETUP_WHO