IBY_FORMATS_VL

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

ROW_ID FORMAT_CODE FORMAT_TYPE_CODE FORMAT_TEMPLATE_CODE REFERENCE_FORMAT_CODE FORMAT_NAME ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 CREATED_BY ATTRIBUTE14 CREATION_DATE ATTRIBUTE15 LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SEEDED_FLAG TRANSFORM_PROGRAM_TYPE TRANSFORM_SRVC_INTERFACE_CLASS TRANSFORM_METHOD CODE_MAP_GROUP_CODE START_DATE END_DATE B2B_DOC_DEFINITION SHREDDING_HANDLED_BY_PARSER PAYLOAD_TYPE_CODE TEMPLATE_DOCUMENT

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.FORMAT_CODE, B.FORMAT_TYPE_CODE, B.FORMAT_TEMPLATE_CODE, B.REFERENCE_FORMAT_CODE, T.FORMAT_NAME, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.CREATED_BY, B.ATTRIBUTE14, B.CREATION_DATE, B.ATTRIBUTE15, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.SEEDED_FLAG, B.TRANSFORM_PROGRAM_TYPE TRANSFORM_PROGRAM_TYPE, B.TRANSFORM_SRVC_INTERFACE_CLASS TRANSFORM_SRVC_INTERFACE_CLASS, B.TRANSFORM_METHOD TRANSFORM_METHOD, B.CODE_MAP_GROUP_CODE CODE_MAP_GROUP_CODE, B.START_DATE START_DATE, B.END_DATE END_DATE, B.B2B_DOC_DEFINITION B2B_DOC_DEFINITION, B.SHREDDING_HANDLED_BY_PARSER, B.PAYLOAD_TYPE_CODE, B.TEMPLATE_DOCUMENT FROM IBY_FORMATS_B B, IBY_FORMATS_TL T WHERE B.FORMAT_CODE = T.FORMAT_CODE AND T.LANGUAGE = USERENV('LANG')