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 ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_NAME	VARCHAR2	(80)		OBJECT_NAME
OBJECT_TYPE	VARCHAR2	(30)		OBJECT_TYPE
DYNAMIC_SQL	VARCHAR2	(4000)		DYNAMIC_SQL
EXCEPTION_STATUS_MSG_CD	VARCHAR2	(30)		EXCEPTION_STATUS_MSG_CD
VALID_STATUS_MSG_CD	VARCHAR2	(30)		VALID_STATUS_MSG_CD
EXCEPTION_VALUE	VARCHAR2	(30)		EXCEPTION_VALUE
IMPACT_MSG_NAME	VARCHAR2	(30)		IMPACT_MSG_NAME
ADD_INFO_URL	VARCHAR2	(200)		ADD_INFO_URL
ENABLED_FLAG	VARCHAR2	(30)		ENABLED_FLAG
FOUNDATION_HR_FLAG	VARCHAR2	(30)		FOUNDATION_HR_FLAG
CREATION_DATE	DATE			CREATION_DATE
CREATED_BY	NUMBER			CREATED_BY
LAST_UPDATE_DATE	DATE			LAST_UPDATE_DATE
LAST_UPDATED_BY	NUMBER			LAST_UPDATED_BY
LAST_UPDATE_LOGIN	NUMBER			LAST_UPDATE_LOGIN
NULL_IMPACT_MSG_NAME	VARCHAR2	(30)		NULL_IMPACT_MSG_NAME
COL_HEADING1	VARCHAR2	(100)		COL_HEADING1
COL_HEADING2	VARCHAR2	(100)		COL_HEADING
COL_HEADING3	VARCHAR2	(100)		COL_HEADING
COL_HEADING4	VARCHAR2	(100)		COL_HEADING
COL_HEADING5	VARCHAR2	(100)		COL_HEADING
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)		DEFAULT_MODE
REPORT_TYPE	VARCHAR2	(30)		REPORT_TYPE
SEQ_NUM	NUMBER			SEQ_NUM
COUNT_HEADING	VARCHAR2	(100)		COUNT_HEADING
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)		FUNCTIONAL_AREA_CD
DYNAMIC_SQL_TYPE	VARCHAR2	(30)		DYNAMIC_SQL_TYPE
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

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
,      ZD_EDITION_NAME
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:

HRI: HRI_ADM_DGNSTC_SETUP#