IBY_TRANSMIT_PARAMETERS

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID TRANSMIT_PARAMETER_CODE TRANSMIT_PARAMETER_TYPE TRANSMIT_PROTOCOL_CODE MANDATORY_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE DISPLAY_ORDER DYNAMIC_FLAG DYN_CODE_LANGUAGE DYN_CODE_PACKAGE DYN_CODE_ENTRY_POINT LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER TRANSMIT_PARAMETER_NAME SECURED_FLAG

Name

ROW_ID

TRANSMIT_PARAMETER_CODE

TRANSMIT_PARAMETER_TYPE

TRANSMIT_PROTOCOL_CODE

MANDATORY_FLAG

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

DISPLAY_ORDER

DYNAMIC_FLAG

DYN_CODE_LANGUAGE

DYN_CODE_PACKAGE

DYN_CODE_ENTRY_POINT

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

TRANSMIT_PARAMETER_NAME

SECURED_FLAG

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.TRANSMIT_PARAMETER_CODE, B.TRANSMIT_PARAMETER_TYPE, B.TRANSMIT_PROTOCOL_CODE, B.MANDATORY_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.DISPLAY_ORDER, B.DYNAMIC_FLAG, B.DYN_CODE_LANGUAGE, B.DYN_CODE_PACKAGE, B.DYN_CODE_ENTRY_POINT, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.TRANSMIT_PARAMETER_NAME, B.SECURED_FLAG FROM IBY_TRANSMIT_PARAMETERS_B B,IBY_TRANSMIT_PARAMETERS_TL T where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE and B.TRANSMIT_PARAMETER_CODE = T.TRANSMIT_PARAMETER_CODE and T.LANGUAGE = userenv('LANG')

SQL_Statement

SELECT B.ROWID ROW_ID, B.TRANSMIT_PARAMETER_CODE, B.TRANSMIT_PARAMETER_TYPE, B.TRANSMIT_PROTOCOL_CODE, B.MANDATORY_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.DISPLAY_ORDER, B.DYNAMIC_FLAG, B.DYN_CODE_LANGUAGE, B.DYN_CODE_PACKAGE, B.DYN_CODE_ENTRY_POINT, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, T.TRANSMIT_PARAMETER_NAME, B.SECURED_FLAG FROM IBY_TRANSMIT_PARAMETERS_B B,IBY_TRANSMIT_PARAMETERS_TL T where B.TRANSMIT_PROTOCOL_CODE = T.TRANSMIT_PROTOCOL_CODE and B.TRANSMIT_PARAMETER_CODE = T.TRANSMIT_PARAMETER_CODE and T.LANGUAGE = userenv('LANG')