HRT_CHANNEL_SETUP_VL

Details

• Schema: FUSION

• Object owner: HRT

• Object type: VIEW

Columns

Name

CHANNEL_ID BUSINESS_GROUP_ID EMAIL_ID CODE TYPE DEPENDENT_CHANNEL_ID ENABLED PAGENAME INCOMING_SERVER_PROTOCOL INCOMING_SERVER_HOST INCOMING_SERVER_PORT INCOMING_SERVER_AUTH_TYPE INCOMING_SERVER_AUTH_KEY INCOMING_SERVER_AUTH_VALUE INCOMING_SERVER_BEARER_TOKEN INCOMING_SERVER_SSL OUTGOING_SERVER_PROTOCOL OUTGOING_SERVER_HOST OUTGOING_SERVER_PORT OUTGOING_SERVER_AUTH_TYPE OUTGOING_SERVER_AUTH_KEY OUTGOING_SERVER_AUTH_VALUE OUTGOING_SERVER_BEARER_TOKEN RECEIVE_FOLDER NAME DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.CHANNEL_ID, B.BUSINESS_GROUP_ID, B.EMAIL_ID, B.CODE, B.TYPE, B.DEPENDENT_CHANNEL_ID, B.ENABLED, B.PAGENAME, B.INCOMING_SERVER_PROTOCOL, B.INCOMING_SERVER_HOST, B.INCOMING_SERVER_PORT, B.INCOMING_SERVER_AUTH_TYPE, B.INCOMING_SERVER_AUTH_KEY, B.INCOMING_SERVER_AUTH_VALUE, B.INCOMING_SERVER_BEARER_TOKEN, B.INCOMING_SERVER_SSL, B.OUTGOING_SERVER_PROTOCOL, B.OUTGOING_SERVER_HOST, B.OUTGOING_SERVER_PORT, B.OUTGOING_SERVER_AUTH_TYPE, B.OUTGOING_SERVER_AUTH_KEY, B.OUTGOING_SERVER_AUTH_VALUE, B.OUTGOING_SERVER_BEARER_TOKEN, B.RECEIVE_FOLDER, TL.NAME, TL.DESCRIPTION, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM HRT_CHANNEL_SETUP_B B, HRT_CHANNEL_SETUP_TL TL WHERE B.CHANNEL_ID = TL.CHANNEL_ID AND B.BUSINESS_GROUP_ID = TL.BUSINESS_GROUP_ID AND TL.LANGUAGE = USERENV('LANG')