Team Role Details: Assignment Details

Description
Categories: Discoverer
The team role details workbook allows you to view the details of open team roles and assignments for organizations and projects.
Owner: SYSADMIN (System Administrator)
Identifier: PA_PRM_TEAM_ROLE_DETAILS
SELECT PA_REP_ASMT_DTS_V.APPROVAL_STATUS, PA_REP_ASMT_DTS_V.ASMT_END_DATE, PA_REP_ASMT_DTS_V.ASMT_START_DATE, PA_REP_ASMT_DTS_V.ASSIGNMENT_NAME, PA_REP_ASMT_DTS_V.BILL_RATE_CURRENCY, PA_REP_ASMT_DTS_V.PROJECT_NAME_NUMBER, PA_REP_ASMT_DTS_V.PROJECT_ORGANIZATION_NAME, PA_REP_ASMT_DTS_V.RESOURCE_NAME, PA_REP_ASMT_DTS_V.RESOURCE_ORGANIZATION, PA_REP_ASMT_DTS_V.SCHEDULE_STATUS, PA_REP_ASMT_DTS_V.WORK_TYPE_NAME, SUM(PA_REP_ASMT_DTS_V.EFFORT_HOURS), SUM(PA_REP_ASMT_DTS_V.CONFIRMED_HOURS), SUM(PA_REP_ASMT_DTS_V.PROVISIONAL_HOURS), SUM(PA_REP_ASMT_DTS_V.RESOURCE_CAPACITY_HOURS), PA_REP_ASMT_DTS_V.ASSIGNMENT_NUMBER, PA_REP_ASMT_DTS_V.RESOURCE_JOB_LEVEL
FROM PA_REP_ASMT_DTS_V PA_REP_ASMT_DTS_V
WHERE 1=1 AND ( PA_REP_ASMT_DTS_V.ASMT_START_DATE <= :start_date_to ) AND ( PA_REP_ASMT_DTS_V.ASMT_START_DATE >= :start_date_from )
GROUP BY PA_REP_ASMT_DTS_V.APPROVAL_STATUS, PA_REP_ASMT_DTS_V.ASMT_END_DATE, PA_REP_ASMT_DTS_V.ASMT_START_DATE, PA_REP_ASMT_DTS_V.ASSIGNMENT_NAME, PA_REP_ASMT_DTS_V.ASSIGNMENT_NUMBER, PA_REP_ASMT_DTS_V.BILL_RATE_CURRENCY, PA_REP_ASMT_DTS_V.PROJECT_NAME_NUMBER, PA_REP_ASMT_DTS_V.PROJECT_ORGANIZATION_NAME, PA_REP_ASMT_DTS_V.RESOURCE_JOB_LEVEL, PA_REP_ASMT_DTS_V.RESOURCE_NAME, PA_REP_ASMT_DTS_V.RESOURCE_ORGANIZATION, PA_REP_ASMT_DTS_V.SCHEDULE_STATUS, PA_REP_ASMT_DTS_V.WORK_TYPE_NAME
Parameter Name SQL text Validation
Assignment Projects
 PA_REP_ASMT_DTS_V.PROJECT_NAME_NUMBER LIKE :assignment_projects
LOV
Role
 PA_REP_ASMT_DTS_V.PROJECT_ROLE_NAME LIKE :role
LOV
Resource
 PA_REP_ASMT_DTS_V.RESOURCE_NAME LIKE :resource
LOV
Assignment Schedule Statuses
 PA_REP_ASMT_DTS_V.SCHEDULE_STATUS LIKE :assignment_schedule_statuses
LOV
Start Date To
 
Date
Start Date From
 
Date