DBA Data[Home] [Help]

VIEW: PA.PA_SCHEDULES_AR#

Source

View Text - Preformatted

select ASSIGNMENT_ID ASSIGNMENT_ID, CALENDAR_ID CALENDAR_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, END_DATE END_DATE, FORECAST_TXN_GENERATED_FLAG FORECAST_TXN_GENERATED_FLAG, FORECAST_TXN_VERSION_NUMBER FORECAST_TXN_VERSION_NUMBER, 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, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ID PROJECT_ID, PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_PROJECT_ID PURGE_PROJECT_ID, PURGE_RELEASE PURGE_RELEASE, REQUEST_ID REQUEST_ID, SATURDAY_HOURS SATURDAY_HOURS, SCHEDULE_ID SCHEDULE_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_SCHEDULES_AR"
View Text - HTML Formatted

SELECT ASSIGNMENT_ID ASSIGNMENT_ID
, CALENDAR_ID CALENDAR_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, END_DATE END_DATE
, FORECAST_TXN_GENERATED_FLAG FORECAST_TXN_GENERATED_FLAG
, FORECAST_TXN_VERSION_NUMBER FORECAST_TXN_VERSION_NUMBER
, 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
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ID PROJECT_ID
, PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, PURGE_RELEASE PURGE_RELEASE
, REQUEST_ID REQUEST_ID
, SATURDAY_HOURS SATURDAY_HOURS
, SCHEDULE_ID SCHEDULE_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_SCHEDULES_AR"