VIEW: APPS.PA_PROJ_ASGN_TIMELINE_ROWLBL_V

Source

View Text - Preformatted

SELECT timeline.ROW_LABEL_ID , timeline.ROW_LABEL_TYPE , timeline.PROJECT_ID , timeline.PROJECT_NUMBER , timeline.PROJECT_NAME , timeline.ASSIGNMENT_ID , timeline.ASSIGNMENT_NAME , timeline.ASSIGNMENT_STATUS , timeline.ASSIGNMENT_START_DATE , timeline.ASSIGNMENT_END_DATE , timeline.RESOURCE_ID , timeline.RESOURCE_NAME , timeline.ORGANIZATION_NAME , timeline.RESOURCE_MGR_NAME , timeline.SCH_UPD_PENDING_FLAG , psp.PROJECT_SUBTEAM_ID , pst.name FROM PA_TIMELINE_ROW_LABEL timeline, pa_project_subteams pst, pa_project_subteam_parties psp WHERE ROW_LABEL_TYPE IN ('OPEN_ASSIGNMENT','STAFFED_ASSIGNMENT') AND timeline.ASSIGNMENT_ID = psp.object_id (+) AND psp.object_type (+) = 'PA_PROJECT_ASSIGNMENTS' AND psp.primary_subteam_flag (+) = 'Y' AND psp.project_subteam_id = pst.project_subteam_id (+) ORDER BY DECODE(ROW_LABEL_TYPE,'OPEN_ASSIGNMENT',1, 'STAFFED_ASSIGNMENT', 2, 3)

View Text - HTML Formatted

SELECT TIMELINE.ROW_LABEL_ID
, TIMELINE.ROW_LABEL_TYPE
, TIMELINE.PROJECT_ID
, TIMELINE.PROJECT_NUMBER
, TIMELINE.PROJECT_NAME
, TIMELINE.ASSIGNMENT_ID
, TIMELINE.ASSIGNMENT_NAME
, TIMELINE.ASSIGNMENT_STATUS
, TIMELINE.ASSIGNMENT_START_DATE
, TIMELINE.ASSIGNMENT_END_DATE
, TIMELINE.RESOURCE_ID
, TIMELINE.RESOURCE_NAME
, TIMELINE.ORGANIZATION_NAME
, TIMELINE.RESOURCE_MGR_NAME
, TIMELINE.SCH_UPD_PENDING_FLAG
, PSP.PROJECT_SUBTEAM_ID
, PST.NAME
FROM PA_TIMELINE_ROW_LABEL TIMELINE
, PA_PROJECT_SUBTEAMS PST
, PA_PROJECT_SUBTEAM_PARTIES PSP
WHERE ROW_LABEL_TYPE IN ('OPEN_ASSIGNMENT'
, 'STAFFED_ASSIGNMENT')
AND TIMELINE.ASSIGNMENT_ID = PSP.OBJECT_ID (+)
AND PSP.OBJECT_TYPE (+) = 'PA_PROJECT_ASSIGNMENTS'
AND PSP.PRIMARY_SUBTEAM_FLAG (+) = 'Y'
AND PSP.PROJECT_SUBTEAM_ID = PST.PROJECT_SUBTEAM_ID (+) ORDER BY DECODE(ROW_LABEL_TYPE
, 'OPEN_ASSIGNMENT'
, 1
, 'STAFFED_ASSIGNMENT'
, 2
, 3)