VIEW: APPS.PA_DEFAULT_PROFILES_V

Source

View Text - Preformatted

SELECT profile.profile_id, profile.profile_name, profile.business_group_id, bg.name, profile.organization_id, hr.name, profile.job_id, pj.name, per.position_id, per.name, lookup.lookup_code, lookup.meaning, profile.description, profile.effective_start_date, profile.effective_end_date FROM PA_ROLE_PROFILES profile, PER_BUSINESS_GROUPS bg, HR_ORGANIZATION_UNITS hr, PER_POSITIONS per, PER_JOBS pj, PA_LOOKUPS lookup WHERE profile.business_group_id = bg.business_group_id (+) AND profile.organization_id = hr.organization_id (+) AND profile.job_id = pj.job_id (+) AND profile.position_id = per.position_id (+) AND profile.profile_type_code = lookup.lookup_code AND lookup.lookup_type = 'PA_ROLE_PROFILE_TYPE' AND resource_id IS NULL

View Text - HTML Formatted

SELECT PROFILE.PROFILE_ID
, PROFILE.PROFILE_NAME
, PROFILE.BUSINESS_GROUP_ID
, BG.NAME
, PROFILE.ORGANIZATION_ID
, HR.NAME
, PROFILE.JOB_ID
, PJ.NAME
, PER.POSITION_ID
, PER.NAME
, LOOKUP.LOOKUP_CODE
, LOOKUP.MEANING
, PROFILE.DESCRIPTION
, PROFILE.EFFECTIVE_START_DATE
, PROFILE.EFFECTIVE_END_DATE
FROM PA_ROLE_PROFILES PROFILE
, PER_BUSINESS_GROUPS BG
, HR_ORGANIZATION_UNITS HR
, PER_POSITIONS PER
, PER_JOBS PJ
, PA_LOOKUPS LOOKUP
WHERE PROFILE.BUSINESS_GROUP_ID = BG.BUSINESS_GROUP_ID (+)
AND PROFILE.ORGANIZATION_ID = HR.ORGANIZATION_ID (+)
AND PROFILE.JOB_ID = PJ.JOB_ID (+)
AND PROFILE.POSITION_ID = PER.POSITION_ID (+)
AND PROFILE.PROFILE_TYPE_CODE = LOOKUP.LOOKUP_CODE
AND LOOKUP.LOOKUP_TYPE = 'PA_ROLE_PROFILE_TYPE'
AND RESOURCE_ID IS NULL