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: PA.PA_SCH_EXCPT_HSTRY_AR#

Source

View Text - Preformatted


select ASSIGNMENT_ID ASSIGNMENT_ID, CALENDAR_ID CALENDAR_ID, CHANGE_CALENDAR_ID CHANGE_CALENDAR_ID, CHANGE_CALENDAR_TYPE_CODE CHANGE_CALENDAR_TYPE_CODE, CHANGE_HOURS_TYPE_CODE CHANGE_HOURS_TYPE_CODE, CHANGE_ID CHANGE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DURATION_SHIFT_TYPE_CODE DURATION_SHIFT_TYPE_CODE, DURATION_SHIFT_UNIT_CODE DURATION_SHIFT_UNIT_CODE, END_DATE END_DATE, EXCEPTION_TYPE_CODE EXCEPTION_TYPE_CODE, FRIDAY_HOURS FRIDAY_HOURS, LAST_UPDATE_BY LAST_UPDATE_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, MONDAY_HOURS MONDAY_HOURS, NON_WORKING_DAY_FLAG NON_WORKING_DAY_FLAG, NUMBER_OF_SHIFT NUMBER_OF_SHIFT, PROJECT_ID PROJECT_ID, PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_PROJECT_ID PURGE_PROJECT_ID, PURGE_RELEASE PURGE_RELEASE, RESOURCE_CALENDAR_PERCENT RESOURCE_CALENDAR_PERCENT, SATURDAY_HOURS SATURDAY_HOURS, SCHEDULE_EXCEPTION_ID SCHEDULE_EXCEPTION_ID, SCHEDULE_TYPE_CODE SCHEDULE_TYPE_CODE, START_DATE START_DATE, STATUS_CODE STATUS_CODE, SUNDAY_HOURS SUNDAY_HOURS, THURSDAY_HOURS THURSDAY_HOURS, TUESDAY_HOURS TUESDAY_HOURS, WEDNESDAY_HOURS WEDNESDAY_HOURS from "PA"."PA_SCH_EXCPT_HSTRY_AR"

View Text - HTML Formatted

SELECT ASSIGNMENT_ID ASSIGNMENT_ID
, CALENDAR_ID CALENDAR_ID
, CHANGE_CALENDAR_ID CHANGE_CALENDAR_ID
, CHANGE_CALENDAR_TYPE_CODE CHANGE_CALENDAR_TYPE_CODE
, CHANGE_HOURS_TYPE_CODE CHANGE_HOURS_TYPE_CODE
, CHANGE_ID CHANGE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DURATION_SHIFT_TYPE_CODE DURATION_SHIFT_TYPE_CODE
, DURATION_SHIFT_UNIT_CODE DURATION_SHIFT_UNIT_CODE
, END_DATE END_DATE
, EXCEPTION_TYPE_CODE EXCEPTION_TYPE_CODE
, FRIDAY_HOURS FRIDAY_HOURS
, LAST_UPDATE_BY LAST_UPDATE_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MONDAY_HOURS MONDAY_HOURS
, NON_WORKING_DAY_FLAG NON_WORKING_DAY_FLAG
, NUMBER_OF_SHIFT NUMBER_OF_SHIFT
, PROJECT_ID PROJECT_ID
, PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, PURGE_RELEASE PURGE_RELEASE
, RESOURCE_CALENDAR_PERCENT RESOURCE_CALENDAR_PERCENT
, SATURDAY_HOURS SATURDAY_HOURS
, SCHEDULE_EXCEPTION_ID SCHEDULE_EXCEPTION_ID
, SCHEDULE_TYPE_CODE SCHEDULE_TYPE_CODE
, START_DATE START_DATE
, STATUS_CODE STATUS_CODE
, SUNDAY_HOURS SUNDAY_HOURS
, THURSDAY_HOURS THURSDAY_HOURS
, TUESDAY_HOURS TUESDAY_HOURS
, WEDNESDAY_HOURS WEDNESDAY_HOURS
FROM "PA"."PA_SCH_EXCPT_HSTRY_AR"