IBY_TRANSMIT_PROTOCOLS

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER TRANSMIT_PROTOCOL_CODE TRANSMIT_CODE_LANGUAGE TRANSMIT_CODE_PACKAGE TRANSMIT_CODE_ENTRY_POINT CREATED_BY CREATION_DATE LAST_UPDATED_BY TRANSMIT_PROTOCOL_NAME

Name

ROW_ID

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

TRANSMIT_PROTOCOL_CODE

TRANSMIT_CODE_LANGUAGE

TRANSMIT_CODE_PACKAGE

TRANSMIT_CODE_ENTRY_POINT

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

TRANSMIT_PROTOCOL_NAME

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.TRANSMIT_PROTOCOL_CODE, B.TRANSMIT_CODE_LANGUAGE, B.TRANSMIT_CODE_PACKAGE, B.TRANSMIT_CODE_ENTRY_POINT, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, T.TRANSMIT_PROTOCOL_NAME from IBY_TRANSMIT_PROTOCOLS_TL T, IBY_TRANSMIT_PROTOCOLS_B B where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE and T.LANGUAGE = userenv('LANG')

SQL_Statement

SELECT B.ROWID ROW_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.TRANSMIT_PROTOCOL_CODE, B.TRANSMIT_CODE_LANGUAGE, B.TRANSMIT_CODE_PACKAGE, B.TRANSMIT_CODE_ENTRY_POINT, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, T.TRANSMIT_PROTOCOL_NAME from IBY_TRANSMIT_PROTOCOLS_TL T, IBY_TRANSMIT_PROTOCOLS_B B where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE and T.LANGUAGE = userenv('LANG')