VIEW: APPS.GMS_OVERRIDE_SCHEDULES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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