VIEW: APPS.PA_PROJ_ASGN_TIME_CHART_V

Source

View Text - Preformatted

SELECT PASGN.PROJECT_ID , PASGN.ASSIGNMENT_ID , PASGN.RESOURCE_ID , PASGN.START_DATE , PASGN.END_DATE , PASGN.SCALE_TYPE , PASGN.COLOR_PATTERN , PASGN.HELP_TEXT , TRWLBL.ROW_LABEL_ID , TRWLBL.ROW_LABEL_TYPE , TRWLBL.PROJECT_NUMBER , TRWLBL.PROJECT_NAME , TRWLBL.ASSIGNMENT_NAME , TRWLBL.ASSIGNMENT_STATUS , TRWLBL.ASSIGNMENT_START_DATE , TRWLBL.ASSIGNMENT_END_DATE , TRWLBL.RESOURCE_NAME , TRWLBL.ORGANIZATION_NAME , TRWLBL.RESOURCE_MGR_NAME , TRWLBL.SCH_UPD_PENDING_FLAG , psp.PROJECT_SUBTEAM_ID , pst.name FROM PA_PROJ_ASGN_TIME_CHART PASGN, PA_PROJ_ASGN_TIMELINE_ROWLBL_V TRWLBL, pa_project_subteams pst, pa_project_subteam_parties psp WHERE PASGN.ROW_LABEL_ID = TRWLBL.ROW_LABEL_ID AND pasgn.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 (+)

View Text - HTML Formatted

SELECT PASGN.PROJECT_ID
, PASGN.ASSIGNMENT_ID
, PASGN.RESOURCE_ID
, PASGN.START_DATE
, PASGN.END_DATE
, PASGN.SCALE_TYPE
, PASGN.COLOR_PATTERN
, PASGN.HELP_TEXT
, TRWLBL.ROW_LABEL_ID
, TRWLBL.ROW_LABEL_TYPE
, TRWLBL.PROJECT_NUMBER
, TRWLBL.PROJECT_NAME
, TRWLBL.ASSIGNMENT_NAME
, TRWLBL.ASSIGNMENT_STATUS
, TRWLBL.ASSIGNMENT_START_DATE
, TRWLBL.ASSIGNMENT_END_DATE
, TRWLBL.RESOURCE_NAME
, TRWLBL.ORGANIZATION_NAME
, TRWLBL.RESOURCE_MGR_NAME
, TRWLBL.SCH_UPD_PENDING_FLAG
, PSP.PROJECT_SUBTEAM_ID
, PST.NAME
FROM PA_PROJ_ASGN_TIME_CHART PASGN
, PA_PROJ_ASGN_TIMELINE_ROWLBL_V TRWLBL
, PA_PROJECT_SUBTEAMS PST
, PA_PROJECT_SUBTEAM_PARTIES PSP
WHERE PASGN.ROW_LABEL_ID = TRWLBL.ROW_LABEL_ID
AND PASGN.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 (+)