PJT_COLUMN_INFO_VL

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name
COLUMN_DISPLAY_NAME TABLE_NAME COLUMN_NAME ENTERPRISE_ID ATTR_DATA_TYPE OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN LANGUAGE

Query

SQL_Statement

SELECT TL.COLUMN_DISPLAY_NAME, B.TABLE_NAME, B.COLUMN_NAME, B.ENTERPRISE_ID, B.ATTR_DATA_TYPE, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, TL.LANGUAGE FROM PJT_COLUMN_INFO_B B, PJT_COLUMN_INFO_TL TL WHERE B.TABLE_NAME = TL.TABLE_NAME AND B.COLUMN_NAME = TL.COLUMN_NAME AND B.ENTERPRISE_ID = TL.ENTERPRISE_ID AND TL.LANGUAGE = USERENV('LANG')