HWR_VLTR_CONTACT_INFO_VL

Details

• Schema: FUSION

• Object owner: HHR

• Object type: VIEW

Columns

Name
ID CONTACT_PHONE CONTACT_FAX EMAIL WEBSITE LOCATION_ID ADDRESS_TYPE ENTITY_ID ENTITY_TYPE CONTACT_TITLE CONTACT_NAME CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT A.ID, A.CONTACT_PHONE, A.CONTACT_FAX, A.EMAIL, A.WEBSITE, A.LOCATION_ID, A.ADDRESS_TYPE, A.ENTITY_ID, A.ENTITY_TYPE, B.CONTACT_TITLE, B.CONTACT_NAME, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN FROM HWR_VLTR_CONTACT_INFO_B A, HWR_VLTR_CONTACT_INFO_TL B WHERE A.ID = B.ID AND B.LANGUAGE = USERENV('LANG')