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]

VIEW: HRI.HRI_ADM_DGNSTC_SETUP#

Object Details

Object Name:	HRI_ADM_DGNSTC_SETUP#
Object Type:	VIEW
Owner:	HRI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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)
OBJECT_NAME_DESC	VARCHAR2	(100)
DEFAULT_MODE	VARCHAR2	(30)
REPORT_TYPE	VARCHAR2	(30)
SEQ_NUM	NUMBER
COUNT_HEADING	VARCHAR2	(100)
OBJECT_TYPE_MSG_NAME	VARCHAR2	(30)
OBJECT_NAME_MSG_NAME	VARCHAR2	(30)
OBJECT_TYPE_DTL_DESC_MSG_NAME	VARCHAR2	(30)
OBJECT_NAME_DTL_DESC_MSG_NAME	VARCHAR2	(30)
FUNCTIONAL_AREA_CD	VARCHAR2	(30)
DYNAMIC_SQL_TYPE	VARCHAR2	(30)
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# references the following:

HRI: HRI_ADM_DGNSTC_SETUP

HRI.HRI_ADM_DGNSTC_SETUP# is referenced by following:

APPS: HRI_ADM_DGNSTC_SETUP; HRI_ADM_DGNSTC_SETUP+; HRI_ADM_DGNSTC_SETUP_WHO