VIEW: APPS.PA_SCHEDULES_V

Source

View Text - Preformatted

SELECT sch.schedule_id SCHEDULE_ID, sch.calendar_id CALENDAR_ID , sch.assignment_id ASSIGNMENT_ID, sch.project_id PROJECT_ID, sch.schedule_type_code SCHEDULE_TYPE_CODE, sch.status_code STATUS_CODE, pst.project_system_status_code SYSTEM_STATUS_CODE, pst.project_status_name ASSIGNMENT_STATUS_DESC, sch.start_date START_DATE, sch.end_date END_DATE, sch.monday_hours MONDAY_HOURS , sch.tuesday_hours TUESDAY_HOURS , sch.wednesday_hours WEDNESDAY_HOURS , sch.thursday_hours THURSDAY_HOURS , sch.friday_hours FRIDAY_HOURS , sch.saturday_hours SATURDAY_HOURS , sch.sunday_hours SUNDAY_HOURS FROM pa_schedules sch, pa_project_statuses pst WHERE sch.status_code = pst.project_status_code

View Text - HTML Formatted

SELECT SCH.SCHEDULE_ID SCHEDULE_ID
, SCH.CALENDAR_ID CALENDAR_ID
, SCH.ASSIGNMENT_ID ASSIGNMENT_ID
, SCH.PROJECT_ID PROJECT_ID
, SCH.SCHEDULE_TYPE_CODE SCHEDULE_TYPE_CODE
, SCH.STATUS_CODE STATUS_CODE
, PST.PROJECT_SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE
, PST.PROJECT_STATUS_NAME ASSIGNMENT_STATUS_DESC
, SCH.START_DATE START_DATE
, SCH.END_DATE END_DATE
, SCH.MONDAY_HOURS MONDAY_HOURS
, SCH.TUESDAY_HOURS TUESDAY_HOURS
, SCH.WEDNESDAY_HOURS WEDNESDAY_HOURS
, SCH.THURSDAY_HOURS THURSDAY_HOURS
, SCH.FRIDAY_HOURS FRIDAY_HOURS
, SCH.SATURDAY_HOURS SATURDAY_HOURS
, SCH.SUNDAY_HOURS SUNDAY_HOURS
FROM PA_SCHEDULES SCH
, PA_PROJECT_STATUSES PST
WHERE SCH.STATUS_CODE = PST.PROJECT_STATUS_CODE