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: APPS.GHR_PA_REQUESTS5_DFV

Object Details

Object Name:	GHR_PA_REQUESTS5_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
TYPE	VARCHAR2	(30)
CERTIFICATE_NO_1	VARCHAR2	(240)
DATE1	DATE
DIRECTIVE_NO_	VARCHAR2	(240)
DATED_	DATE
DECISION_NO_1	VARCHAR2	(240)
DATE2	DATE
LETTER_NO_1	VARCHAR2	(240)
FORM_1652_OR_OPM_LTR__DATE_	DATE
AUTHORITY_NO_1	VARCHAR2	(240)
OPM_OFFICE1	VARCHAR2	(240)
AUTHORITY_NO_2	VARCHAR2	(150)
DATE3	DATE
CERT_NO_	VARCHAR2	(240)
EA_NO_1	VARCHAR2	(240)
INSTALLATION2	VARCHAR2	(150)
CERTIFICATE_NO_3	VARCHAR2	(150)
MC_NO_1	VARCHAR2	(240)
NW_NO_1	VARCHAR2	(240)
RM_NO_1	VARCHAR2	(240)
AGREEMENT_NO_1	VARCHAR2	(240)
LEGAL_AUTHORITY1	VARCHAR2	(240)
LAW__E_O___OR_REG_	VARCHAR2	(240)
AGENCY_DIRECTIVE_1	VARCHAR2	(240)
AGENCY_REGULATION1	VARCHAR2	(240)
LAW_OR_REGULATION1	VARCHAR2	(240)
LAW_E_O_REG_	VARCHAR2	(240)
AGENCY_AUTHORITY	VARCHAR2	(150)
SCH_B__213_32_	VARCHAR2	(240)
SCH_C__213_33_	VARCHAR2	(240)
NAME	VARCHAR2	(240)
CERT__NO_	VARCHAR2	(150)
AUTHORITY	VARCHAR2	(240)
DATE_	VARCHAR2	(150)
CITATION1	VARCHAR2	(240)
OTHER_CITATION	VARCHAR2	(240)
CONCATENATED_SEGMENTS	VARCHAR2	(573)

Query Text

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


SELECT ROW_ID
,      TYPE
,      CERTIFICATE_NO_1
,      DATE1
,      DIRECTIVE_NO_
,      DATED_
,      DECISION_NO_1
,      DATE2
,      LETTER_NO_1
,      FORM_1652_OR_OPM_LTR__DATE_
,      AUTHORITY_NO_1
,      OPM_OFFICE1
,      AUTHORITY_NO_2
,      DATE3
,      CERT_NO_
,      EA_NO_1
,      INSTALLATION2
,      CERTIFICATE_NO_3
,      MC_NO_1
,      NW_NO_1
,      RM_NO_1
,      AGREEMENT_NO_1
,      LEGAL_AUTHORITY1
,      LAW__E_O___OR_REG_
,      AGENCY_DIRECTIVE_1
,      AGENCY_REGULATION1
,      LAW_OR_REGULATION1
,      LAW_E_O_REG_
,      AGENCY_AUTHORITY
,      SCH_B__213_32_
,      SCH_C__213_33_
,      NAME
,      CERT__NO_
,      AUTHORITY
,      DATE_
,      CITATION1
,      OTHER_CITATION
,      CONCATENATED_SEGMENTS
FROM APPS.GHR_PA_REQUESTS5_DFV;

Dependencies

[top of page]

APPS.GHR_PA_REQUESTS5_DFV references the following:

APPS: GHR_PA_REQUESTS

APPS.GHR_PA_REQUESTS5_DFV is not referenced by any database object