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: GMS.GMS_425_HISTORY#

Object Details

Object Name:	GMS_425_HISTORY#
Object Type:	VIEW
Owner:	GMS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REPORT_TRN_ID	NUMBER	(15)	Yes
AWARD_ID	NUMBER	(15)	Yes
VERSION	NUMBER	(15)	Yes
STATUS_CODE	VARCHAR2	(3)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
RUN_DATE	DATE		Yes
REPORT_START_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
REPORT_TYPE_CODE	VARCHAR2	(150)	Yes
BASIS_OF_ACCNT_CODE	VARCHAR2	(120)	Yes
GRANT_PERIOD_FROM_DATE	DATE		Yes
GRANT_PERIOD_TO_DATE	DATE		Yes
REPORT_END_DATE	DATE		Yes
CASH_RECEIPTS_AMT	NUMBER	(22)
CASH_DISBURSEMENTS_AMT	NUMBER	(22)
TOTAL_FED_FUNDS_AUTH_AMT	NUMBER	(22)
FED_SHARE_OF_EXP_AMT	NUMBER	(22)
FED_SHARE_OF_UNLIQ_OBL_AMT	NUMBER	(22)
TOTAL_RECPT_SHARE_REQ_AMT	NUMBER	(22)
RECPT_SHARE_EXP_AMT	NUMBER	(22)
TOTAL_FED_PRG_INC_EARN_AMT	NUMBER	(22)
PRG_INC_EXP_DEDUCT_ALT_AMT	NUMBER	(22)
PRG_INC_EXP_ADD_ALT_AMT	NUMBER	(22)
REMARKS	VARCHAR2	(2000)
NAME	VARCHAR2	(360)
TELEPHONE	VARCHAR2	(360)
EMAIL	VARCHAR2	(240)
REPORT_SUBMIT_DATE	DATE

Query Text

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


SELECT REPORT_TRN_ID
,      AWARD_ID
,      VERSION
,      STATUS_CODE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      RUN_DATE
,      REPORT_START_DATE
,      CREATED_BY
,      REPORT_TYPE_CODE
,      BASIS_OF_ACCNT_CODE
,      GRANT_PERIOD_FROM_DATE
,      GRANT_PERIOD_TO_DATE
,      REPORT_END_DATE
,      CASH_RECEIPTS_AMT
,      CASH_DISBURSEMENTS_AMT
,      TOTAL_FED_FUNDS_AUTH_AMT
,      FED_SHARE_OF_EXP_AMT
,      FED_SHARE_OF_UNLIQ_OBL_AMT
,      TOTAL_RECPT_SHARE_REQ_AMT
,      RECPT_SHARE_EXP_AMT
,      TOTAL_FED_PRG_INC_EARN_AMT
,      PRG_INC_EXP_DEDUCT_ALT_AMT
,      PRG_INC_EXP_ADD_ALT_AMT
,      REMARKS
,      NAME
,      TELEPHONE
,      EMAIL
,      REPORT_SUBMIT_DATE
FROM GMS.GMS_425_HISTORY#;

Dependencies

[top of page]

GMS.GMS_425_HISTORY# references the following:

GMS: GMS_425_HISTORY

GMS.GMS_425_HISTORY# is referenced by following:

APPS: GMS_425_HISTORY