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: HR.GHR_COMPL_AGENCY_APPEALS#

Object Details

Object Name:	GHR_COMPL_AGENCY_APPEALS#
Object Type:	VIEW
Owner:	HR
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
COMPL_AGENCY_APPEAL_ID	NUMBER	(15)	Yes
COMPLAINT_ID	NUMBER	(15)	Yes
APPEAL_DATE	DATE
REASON_FOR_APPEAL	VARCHAR2	(30)
SOURCE_DECISION_DATE	DATE
DOCKET_NUM	VARCHAR2	(250)
AGENCY_RECVD_REQ_FOR_FILES	DATE
FILES_DUE	DATE
FILES_FORWD	DATE
AGENCY_BRIEF_DUE	DATE
AGENCY_BRIEF_FORWD	DATE
AGENCY_RECVD_APPELLANT_BRIEF	DATE
DECISION_DATE	DATE
DEC_RECVD_BY_AGENCY	DATE
DECISION	VARCHAR2	(30)
DEC_FORWD_TO_ORG	DATE
AGENCY_RFR_SUSPENSE	DATE
REQUEST_FOR_RFR	DATE
RFR_DOCKET_NUM	VARCHAR2	(50)
RFR_REQUESTED_BY	VARCHAR2	(30)
AGENCY_RFR_DUE	DATE
RFR_FORWD_TO_ORG	DATE
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
ORG_FORWD_RFR_TO_AGENCY	DATE
AGENCY_FORWD_RFR_OFO	DATE
RFR_DECISION_DATE	DATE
AGENCY_RECVD_RFR_DEC	DATE
RFR_DECISION_FORWD_TO_ORG	DATE
RFR_DECISION	VARCHAR2	(30)
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes
CREATED_BY	NUMBER	(15)	Yes

Query Text

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


SELECT COMPL_AGENCY_APPEAL_ID
,      COMPLAINT_ID
,      APPEAL_DATE
,      REASON_FOR_APPEAL
,      SOURCE_DECISION_DATE
,      DOCKET_NUM
,      AGENCY_RECVD_REQ_FOR_FILES
,      FILES_DUE
,      FILES_FORWD
,      AGENCY_BRIEF_DUE
,      AGENCY_BRIEF_FORWD
,      AGENCY_RECVD_APPELLANT_BRIEF
,      DECISION_DATE
,      DEC_RECVD_BY_AGENCY
,      DECISION
,      DEC_FORWD_TO_ORG
,      AGENCY_RFR_SUSPENSE
,      REQUEST_FOR_RFR
,      RFR_DOCKET_NUM
,      RFR_REQUESTED_BY
,      AGENCY_RFR_DUE
,      RFR_FORWD_TO_ORG
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_FORWD_RFR_TO_AGENCY
,      AGENCY_FORWD_RFR_OFO
,      RFR_DECISION_DATE
,      AGENCY_RECVD_RFR_DEC
,      RFR_DECISION_FORWD_TO_ORG
,      RFR_DECISION
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
FROM HR.GHR_COMPL_AGENCY_APPEALS#;

Dependencies

[top of page]

HR.GHR_COMPL_AGENCY_APPEALS# references the following:

HR: GHR_COMPL_AGENCY_APPEALS

HR.GHR_COMPL_AGENCY_APPEALS# is referenced by following:

APPS: GHR_COMPL_AGENCY_APPEALS; GHR_COMPL_AGENCY_APPEALS_WHO