EGI_IO_MAP_VL

Details

• Schema: FUSION

• Object owner: EGI

• Object type: VIEW

Columns

Name

MAPPING_ID DEFAULT_FLAG TYPE MAPPING_CODE MAPPING_NAME MAPPING_DESCRIPTION OBJECT_NAME GENERIC_MAP_FLAG ITEM_CLASS_ID ACTIVE_FLAG FILE_TYPE FILE_SELECTION ENCODING_TYPE DATE_FORMAT DATA_DELIMETER TIMESTAMP_FORMAT UPLOAD_FROM PARENT_MAPPING_ID INT_EXT_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN INCLUDE_REQUIRED_ATTRIBUTES DELIMITER DELIMITER_VALUE

Query

SQL_Statement

SELECT B.MAPPING_ID MAPPING_ID, B.DEFAULT_FLAG DEFAULT_FLAG, B.TYPE TYPE, B.MAPPING_CODE MAPPING_CODE, TL.MAPPING_NAME MAPPING_NAME, TL.MAPPING_DESCRIPTION MAPPING_DESCRIPTION, B.OBJECT_NAME OBJECT_NAME, B.GENERIC_MAP_FLAG GENERIC_MAP_FLAG, B.ITEM_CLASS_ID ITEM_CLASS_ID, B.ACTIVE_FLAG ACTIVE_FLAG, B.FILE_TYPE FILE_TYPE, B.FILE_SELECTION FILE_SELECTION, B.ENCODING_TYPE ENCODING_TYPE, B.DATE_FORMAT DATE_FORMAT, B.DATA_DELIMETER DATA_DELIMETER, B.TIMESTAMP_FORMAT TIMESTAMP_FORMAT, B.UPLOAD_FROM UPLOAD_FROM, B.PARENT_MAPPING_ID PARENT_MAPPING_ID, B.INT_EXT_FLAG INT_EXT_FLAG, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, B.INCLUDE_REQUIRED_ATTRIBUTES INCLUDE_REQUIRED_ATTRIBUTES, B.DELIMITER DELIMITER, B.DELIMITER_VALUE DELIMITER_VALUE FROM EGI_IO_MAP_B B, EGI_IO_MAP_TL TL WHERE B.MAPPING_ID = TL.MAPPING_ID AND TL.LANGUAGE = USERENV('LANG')