Product: | PA - Projects |
---|---|
Description: | PA_SCHEDULES_V displays the schedule details for requirements and assignments. It also displays calendar schedules |
Implementation/DBA Data: | APPS.PA_SCHEDULES_V |
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