VIEW: APPS.PA_RES_PROFILES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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