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.

[Home] [Help]

View: GMS_OVERRIDE_SCHEDULES_V

Product:	GMS - Grants Accounting
Description:
Implementation/DBA Data:	APPS.GMS_OVERRIDE_SCHEDULES_V

View Text

SELECT GIO.ROWID
, GIO.AWARD_ID
, PP.PROJECT_ID
, PP.SEGMENT1
, PP.NAME
, PT.TASK_ID
, PT.TASK_NUMBER
, PT.TASK_NAME
, PAIND.IND_RATE_SCH_ID
, PAIND.IND_RATE_SCH_NAME
, GIO.COST_IND_SCH_FIXED_DATE
, PAIND.IND_RATE_SCHEDULE_TYPE
, GIO.LAST_UPDATE_DATE
, GIO.LAST_UPDATED_BY
, GIO.CREATION_DATE
, GIO.CREATED_BY
, GIO.LAST_UPDATE_LOGIN
, PP.ORG_ID
FROM GMS_OVERRIDE_SCHEDULES GIO
, PA_IND_RATE_SCHEDULES PAIND
, PA_TASKS PT
, PA_PROJECTS PP
WHERE GIO.PROJECT_ID =PP.PROJECT_ID
AND GIO.TASK_ID =PT.TASK_ID(+)
AND GIO.IDC_SCHEDULE_ID = PAIND.IND_RATE_SCH_ID

Columns

Name
ROW_ID
AWARD_ID
PROJECT_ID
PROJECT_NUMBER
PROJECT_NAME
TASK_ID
TASK_NUMBER
TASK_NAME
IDC_SCHEDULE_ID
IDC_SCHEDULE_NAME
IDC_SCHEDULE_FIXED_DATE
IDC_SCHEDULE_TYPE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ORG_ID