IBY_FORMAT_TYPES_VL

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name
ROW_ID FORMAT_TYPE_CODE MESSAGE_DIRECTION XML_SCHEMA_CODE XML_SCHEMA_XDB_URL LOADER_SERVICE_INTERFACE_CLASS LOADER_SDO LOADER_SDO_MERGE_METHOD IMPORTER_SRVC_INTERFACE_CLASS IMPORT_METHOD EXTRACT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER FORMAT_TYPE_NAME DESCRIPTION BIP_CATALOG_REPORT_ABS_PATH LOAD_PROGRAM_TYPE

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.FORMAT_TYPE_CODE FORMAT_TYPE_CODE, B.MESSAGE_DIRECTION MESSAGE_DIRECTION, B.XML_SCHEMA_CODE XML_SCHEMA_CODE, B.XML_SCHEMA_XDB_URL XML_SCHEMA_XDB_URL, B.LOADER_SERVICE_INTERFACE_CLASS LOADER_SERVICE_INTERFACE_CLASS, B.LOADER_SDO LOADER_SDO, B.LOADER_SDO_MERGE_METHOD LOADER_SDO_MERGE_METHOD, B.IMPORTER_SRVC_INTERFACE_CLASS IMPORTER_SRVC_INTERFACE_CLASS, B.IMPORT_METHOD IMPORT_METHOD, B.EXTRACT_ID EXTRACT_ID, 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.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TL.FORMAT_TYPE_NAME FORMAT_TYPE_NAME, TL.DESCRIPTION DESCRIPTION, B.BIP_CATALOG_REPORT_ABS_PATH BIP_CATALOG_REPORT_ABS_PATH, B.LOAD_PROGRAM_TYPE LOAD_PROGRAM_TYPE FROM IBY_FORMAT_TYPES_B B, IBY_FORMAT_TYPES_TL TL WHERE B.FORMAT_TYPE_CODE = TL.FORMAT_TYPE_CODE AND TL.LANGUAGE = USERENV('LANG')