[Home] [Help]
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
Name |
PROFILE_ID |
PROFILE_NAME |
RESOURCE_ID |
PROFILE_TYPE_CODE |
PROFILE_TYPE_NAME |
DESCRIPTION |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
APPROVAL_STATUS_CODE |
APPROVAL_STATUS_NAME |
CURRENT_FLAG |