VIEW: PA.PA_SCHEDULES_HISTORY#

Source

View Text - Preformatted

select SCHEDULE_ID SCHEDULE_ID, CALENDAR_ID CALENDAR_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PROJECT_ID PROJECT_ID, SCHEDULE_TYPE_CODE SCHEDULE_TYPE_CODE, STATUS_CODE STATUS_CODE, START_DATE START_DATE, END_DATE END_DATE, MONDAY_HOURS MONDAY_HOURS, TUESDAY_HOURS TUESDAY_HOURS, WEDNESDAY_HOURS WEDNESDAY_HOURS, THURSDAY_HOURS THURSDAY_HOURS, FRIDAY_HOURS FRIDAY_HOURS, SATURDAY_HOURS SATURDAY_HOURS, SUNDAY_HOURS SUNDAY_HOURS, CHANGE_ID CHANGE_ID, LAST_APPROVED_FLAG LAST_APPROVED_FLAG, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_BY LAST_UPDATE_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN from "PA"."PA_SCHEDULES_HISTORY"

View Text - HTML Formatted

SELECT SCHEDULE_ID SCHEDULE_ID
, CALENDAR_ID CALENDAR_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PROJECT_ID PROJECT_ID
, SCHEDULE_TYPE_CODE SCHEDULE_TYPE_CODE
, STATUS_CODE STATUS_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, MONDAY_HOURS MONDAY_HOURS
, TUESDAY_HOURS TUESDAY_HOURS
, WEDNESDAY_HOURS WEDNESDAY_HOURS
, THURSDAY_HOURS THURSDAY_HOURS
, FRIDAY_HOURS FRIDAY_HOURS
, SATURDAY_HOURS SATURDAY_HOURS
, SUNDAY_HOURS SUNDAY_HOURS
, CHANGE_ID CHANGE_ID
, LAST_APPROVED_FLAG LAST_APPROVED_FLAG
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_BY LAST_UPDATE_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM "PA"."PA_SCHEDULES_HISTORY"