HWR_COMBO_PROFILE_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
FULL_NAME FIRST_NAME MIDDLE_NAME LAST_NAME EMAIL LAST_UPDATE_DATE LANGUAGES IS_ACTIVE_FLAG SOURCE_ID USER_DISTINGUISHED_NAME USER_GUID USER_ID USERNAME MULTITENANCY_USERNAME ABOUT_ME ALIAS ASSOCIATIONS CAREER_STATEMENT COMPANY_NAME CURRENT_STATUS HEADLINE HONORS IMAGE_URL INDUSTRY PRFL_ID INTERESTS SKILLS SPECIALTIES TITLE URL STREET_ADDRESS M_USERNAME

Query

SQL_Statement

SELECT P.FULL_NAME, P.FIRST_NAME, P.MIDDLE_NAME, P.LAST_NAME, P.EMAIL, P.LAST_UPDATE_DATE, P.LANGUAGES, P.IS_ACTIVE_FLAG, P.SOURCE_ID, P.USER_DISTINGUISHED_NAME, P.USER_GUID, P.USER_ID, P.USERNAME, P.MULTITENANCY_USERNAME, P.ABOUT_ME, P.ALIAS, P.ASSOCIATIONS, P.CAREER_STATEMENT, P.COMPANY_NAME, P.CURRENT_STATUS, P.HEADLINE, P.HONORS, P.IMAGE_URL, P.INDUSTRY, P.PRFL_ID, P.INTERESTS, P.SKILLS, P.SPECIALTIES, P.TITLE, P.URL, CASE WHEN T.SOURCE_ID = P.F THEN NULL ELSE T.STREET_ADDRESS END AS STREET_ADDRESS, CASE WHEN P.SOURCE_ID = P.F THEN ( SELECT MULTITENANCY_USERNAME FROM PER_USERS WHERE PERSON_ID = P.PRFL_ID ) ELSE P.MULTITENANCY_USERNAME END AS M_USERNAME FROM HWR_PER_PROFILE_TL T, ( SELECT NVL2(PROFILEB_1.FIRST_NAME,PROFILEB_1.FIRST_NAME || ' ','') || NVL2(PROFILEB_1.MIDDLE_NAME,PROFILEB_1.MIDDLE_NAME || ' ','') || NVL2(PROFILEB_1.LAST_NAME,PROFILEB_1.LAST_NAME || ' ','') AS FULL_NAME, PROFILEB_1.CREATION_DATE, PROFILEB_1.EMAIL, PROFILEB_1.LAST_UPDATE_DATE, PROFILEB_1.FIRST_NAME, PROFILEB_1.IS_ACTIVE_FLAG, PROFILEB_1.PRFL_ID, PROFILEB_1.MIDDLE_NAME, PROFILEB_1.LAST_NAME, PROFILEB_1.SOURCE_ID, PROFILEB_1.USER_DISTINGUISHED_NAME, PROFILEB_1.USER_GUID, PROFILEB_1.USER_ID, PROFILEB_1.USERNAME, PROFILEB_1.MULTITENANCY_USERNAME, PROFILEB_1.GENDER_CODE, S.F, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.ABOUT_ME END AS ABOUT_ME, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.ALIAS END AS ALIAS, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.ASSOCIATIONS END AS ASSOCIATIONS, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.CAREER_STATEMENT END AS CAREER_STATEMENT, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.COMPANY_NAME END AS COMPANY_NAME, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.CURRENT_STATUS END AS CURRENT_STATUS, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.HEADLINE END AS HEADLINE, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.HONORS END AS HONORS, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.IMAGE_URL END AS IMAGE_URL, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.INDUSTRY END AS INDUSTRY, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.INTERESTS END AS INTERESTS, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.LANGUAGES END AS LANGUAGES, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.SKILLS END AS SKILLS, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.SPECIALTIES END AS SPECIALTIES, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.TITLE END AS TITLE, CASE WHEN PROFILEB_1.SOURCE_ID = S.F THEN NULL ELSE PROFILEB_1.URL END AS URL FROM HWR_PER_PROFILE_B PROFILEB_1, ( SELECT SRCB.SOURCE_ID AS F FROM HWR_SRC_SOURCE_B SRCB INNER JOIN HWR_SRC_SRCTYPE_B STB ON SRCB.SOURCE_TYPE_ID = STB.SOURCE_TYPE_ID WHERE STB.SOURCE_TYPE_KEY = 'Fusion' ) S WHERE PROFILEB_1.IS_ACTIVE_FLAG = 'Y' ) P WHERE T.PRFL_ID = P.PRFL_ID AND T.SOURCE_ID = P.SOURCE_ID AND T.LANGUAGE = USERENV('LANG')