HWR_VLTR_ADDRESS_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name
ADDRESS_ID ADDRESS_TYPE ZIP ENTITY_ID ENTITY_TYPE ADDRESS_LINE_1 ADDRESS_LINE_2 CITY STATE COUNTRY CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ZIP_CODE HCM_PERSON_ID LONGITUDE LATITUDE

Query

SQL_Statement

SELECT A.ADDRESS_ID ADDRESS_ID, A.ADDRESS_TYPE ADDRESS_TYPE, A.ZIP ZIP, A.ENTITY_ID ENTITY_ID, A.ENTITY_TYPE ENTITY_TYPE, B.ADDRESS_LINE_1 ADDRESS_LINE_1, B.ADDRESS_LINE_2 ADDRESS_LINE_2, B.CITY CITY, B.STATE STATE, B.COUNTRY COUNTRY, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, A.ZIP_CODE ZIP_CODE, A.HCM_PERSON_ID, A.LONGITUDE LONGITUDE, A.LATITUDE LATITUDE FROM HWR_VLTR_ADDRESS_B A, HWR_VLTR_ADDRESS_TL B WHERE A.ADDRESS_ID = B.ADDRESS_ID AND B.LANGUAGE = USERENV('LANG')