PJT_COLUMN_MAP_VL

Details

• Schema: FUSION

• Object owner: PJT

• Object type: VIEW

Columns

Name
COLUMN_HEADER_TEXT COLUMN_MAP_ID TABLE_NAME COLUMN_NAME OBJECT_TYPE GLOBAL_FLAG ATTR_DATA_TYPE ENABLED_FLAG PROJECT_ID OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN DESCRIPTION LANGUAGE

Query

SQL_Statement

SELECT TL.COLUMN_HEADER_TEXT, B.COLUMN_MAP_ID, B.TABLE_NAME, B.COLUMN_NAME, B.OBJECT_TYPE, B.GLOBAL_FLAG, B.ATTR_DATA_TYPE, B.ENABLED_FLAG, B.PROJECT_ID, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, TL.DESCRIPTION, TL.LANGUAGE FROM PJT_COLUMN_MAP_B B, PJT_COLUMN_MAP_TL TL WHERE B.COLUMN_MAP_ID = TL.COLUMN_MAP_ID AND TL.LANGUAGE = USERENV('LANG')