HWR_PER_ORGANIZATION_VL

Details

• Schema: FUSION

• Object owner: HWR

• Object type: VIEW

Columns

Name
HWR_ORG_ID ORG_SIZE NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.HWR_ORG_ID, B.ORG_SIZE, T.NAME, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM HWR_PER_ORGANIZATION_B B, HWR_PER_ORGANIZATION_TL T WHERE B.HWR_ORG_ID = T.HWR_ORG_ID AND T.LANGUAGE = USERENV('LANG')