View: PA_TEMPLATE_REQUIREMENTS_V

Product:	PA - Projects
Description:
Implementation/DBA Data:	APPS.PA_TEMPLATE_REQUIREMENTS_V

View Text

SELECT ASGN.ROWID
, ASGN.ASSIGNMENT_ID
, ASGN.ASSIGNMENT_NAME
, ASGN.ASSIGNMENT_TYPE
, ASGN.MULTIPLE_STATUS_FLAG
, ASGN.RECORD_VERSION_NUMBER
, ASGN.STATUS_CODE STATUS_CODE
, PS.PROJECT_STATUS_NAME STATUS_NAME
, ASGN.ASSIGNMENT_TEMPLATE_ID
, TT.TEAM_TEMPLATE_NAME
, ASGN.PROJECT_ROLE_ID
, PRT.MEANING PROJECT_ROLE_NAME
, PSP.PROJECT_SUBTEAM_ID
, PST.NAME PROJECT_SUB_TEAM_NAME
, PSP.PROJECT_SUBTEAM_PARTY_ID
, ASGN.START_DATE
, ASGN.END_DATE
, (TRUNC(ASGN.END_DATE) - TRUNC(ASGN.START_DATE) +1 ) ASSIGNMENT_DURATION
, ASGN.ASSIGNMENT_EFFORT
, ASGN.EXTENSION_POSSIBLE
, ASGN.MIN_RESOURCE_JOB_LEVEL
, ASGN.MAX_RESOURCE_JOB_LEVEL
, ASGN.ASSIGNMENT_NUMBER
, ASGN.ADDITIONAL_INFORMATION
, ASGN.LOCATION_ID
, LOC.CITY
, LOC.REGION
, LOC.COUNTRY_CODE
, FTT.TERRITORY_SHORT_NAME
, ASGN.DESCRIPTION
, ASGN.NOTE_TO_APPROVER
, ASGN.CALENDAR_ID
, CALTL.CALENDAR_NAME
, ASGN.CALENDAR_TYPE
, ASGN.RESOURCE_CALENDAR_PERCENT
, ASGN.WORK_TYPE_ID
, WT.NAME
, PL.MEANING
, ASGN.STAFFING_PRIORITY_CODE
, ASGN.ATTRIBUTE_CATEGORY
, ASGN.ATTRIBUTE1
, ASGN.ATTRIBUTE2
, ASGN.ATTRIBUTE3
, ASGN.ATTRIBUTE4
, ASGN.ATTRIBUTE5
, ASGN.ATTRIBUTE6
, ASGN.ATTRIBUTE7
, ASGN.ATTRIBUTE8
, ASGN.ATTRIBUTE9
, ASGN.ATTRIBUTE10
, ASGN.ATTRIBUTE11
, ASGN.ATTRIBUTE12
, ASGN.ATTRIBUTE13
, ASGN.ATTRIBUTE14
, ASGN.ATTRIBUTE15
FROM PA_TEAM_TEMPLATES TT
, PA_PROJECT_ASSIGNMENTS ASGN
, PA_PROJECT_ROLE_TYPES PRT
, PA_PROJECT_STATUSES PS
, PA_LOCATIONS LOC
, FND_TERRITORIES_TL FTT
, JTF_CALENDARS_TL CALTL
, PA_WORK_TYPES_V WT
, PA_LOOKUPS PL
, PA_PROJECT_SUBTEAMS PST
, PA_PROJECT_SUBTEAM_PARTIES PSP
WHERE ASGN.ASSIGNMENT_TEMPLATE_ID = TT.TEAM_TEMPLATE_ID
AND ASGN.PROJECT_ROLE_ID = PRT.PROJECT_ROLE_ID
AND ASGN.STATUS_CODE = PS.PROJECT_STATUS_CODE
AND ASGN.LOCATION_ID = LOC.LOCATION_ID (+)
AND LOC.COUNTRY_CODE = FTT.TERRITORY_CODE (+)
AND FTT.LANGUAGE(+) = USERENV('LANG')
AND ASGN.CALENDAR_ID = CALTL.CALENDAR_ID(+)
AND CALTL.LANGUAGE(+) = USERENV('LANG')
AND ASGN.WORK_TYPE_ID = WT.WORK_TYPE_ID
AND PL.LOOKUP_TYPE(+) = 'STAFFING_PRIORITY_CODE'
AND ASGN.STAFFING_PRIORITY_CODE = PL.LOOKUP_CODE(+)
AND ASGN.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(+)
AND ASGN.TEMPLATE_FLAG='Y'

Columns