Team Role Details: Assignment Details

Description
Categories: Discoverer
Columns: Approval Status, Asmt End Date, Asmt Start Date, Assignment Name, Bill Rate Currency, Project Name Number, Project Organization Name, Resource Name, Resource Organization, Schedule Status ...
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 From
 
Date
Start Date To
 
Date