HRT_PROFILES_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name
PROFILE_ID BUSINESS_GROUP_ID DESCRIPTION SUMMARY PROFILE_TYPE_ID PROFILE_CODE PROFILE_STATUS_CODE PROFILE_USAGE_CODE PERSON_ID PARTY_ID OWNER_PERSON_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CAREER_AMBASSADOR_FLAG REVIEW_REQD_FLAG CAREER_AMBASSADOR_SUMMARY

Query

SQL_Statement

SELECT PR.PROFILE_ID, PR.BUSINESS_GROUP_ID, PRT.DESCRIPTION, PRT.SUMMARY, PR.PROFILE_TYPE_ID, PR.PROFILE_CODE, PR.PROFILE_STATUS_CODE, PR.PROFILE_USAGE_CODE, PR.PERSON_ID, PR.PARTY_ID, PR.OWNER_PERSON_ID, PR.OBJECT_VERSION_NUMBER, PR.CREATED_BY, PR.CREATION_DATE, PR.LAST_UPDATED_BY, PR.LAST_UPDATE_DATE, PR.LAST_UPDATE_LOGIN, PR.CAREER_AMBASSADOR_FLAG, PR.REVIEW_REQD_FLAG, PRT.CAREER_AMBASSADOR_SUMMARY FROM HRT_PROFILES_B PR, HRT_PROFILES_TL PRT WHERE PR.PROFILE_ID = PRT.PROFILE_ID AND PRT.LANGUAGE = USERENV('LANG')