View: PA_RES_PROFILES_V

Product:	PA - Projects
Description:	This view shows the detail information of the resource role profiles
Implementation/DBA Data:	APPS.PA_RES_PROFILES_V

View Text

SELECT PROFILE.PROFILE_ID
, PROFILE.PROFILE_NAME
, PROFILE.RESOURCE_ID
, PROFILE.PROFILE_TYPE_CODE
, LOOKUP.MEANING
, PROFILE.DESCRIPTION
, PROFILE.EFFECTIVE_START_DATE
, PROFILE.EFFECTIVE_END_DATE
, STATUS.PROJECT_STATUS_CODE
, STATUS.PROJECT_STATUS_NAME
, DECODE(PROFILE.PROFILE_ID
, (SELECT PF2.PROFILE_ID
FROM PA_ROLE_PROFILES PF2
WHERE PF2.PROFILE_ID = PROFILE.PROFILE_ID
AND SYSDATE BETWEEN PF2.EFFECTIVE_START_DATE
AND NVL(PF2.EFFECTIVE_END_DATE
, PF2.EFFECTIVE_START_DATE)
AND PF2.RESOURCE_ID IS NOT NULL
AND PF2.PROFILE_TYPE_CODE = 'ACTUAL')
, 'Y'
, 'N')
FROM PA_ROLE_PROFILES PROFILE
, PA_LOOKUPS LOOKUP
, PA_PROJECT_STATUSES STATUS
WHERE PROFILE.PROFILE_TYPE_CODE = LOOKUP.LOOKUP_CODE
AND LOOKUP.LOOKUP_TYPE = 'PA_ROLE_PROFILE_TYPE'
AND STATUS.STATUS_TYPE='ASGMT_APPRVL'
AND PROFILE.APPROVAL_STATUS_CODE = STATUS.PROJECT_STATUS_CODE

Columns