FUN_STREAM_TYPES_VL

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name

STREAM_TYPE_ID APPLICATION_ID PROCESS_NAME STREAM_TYPE_CODE MASTER_STREAM_FLAG PREPROCESS_TYPE_CODE PREPROCESS_PACKAGE PREPROCESS_API NOTIFICATION_ROLE_CODE NOTIFICATION_TYPE_CODE NOTIFICATION_PROCESS_URL ERROR_NOTIFICATION_ROLE_CODE ERROR_NOTIFICATION_TYPE_CODE ERROR_NOTIFICATION_PROCESS_URL NOTIFICATION_FLAG ENABLED_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN RECORD_TYPE_CODE STREAM_TYPE_NAME

Query

SQL_Statement

SELECT B.STREAM_TYPE_ID, B.APPLICATION_ID, B.PROCESS_NAME, B.STREAM_TYPE_CODE, B.MASTER_STREAM_FLAG, B.PREPROCESS_TYPE_CODE, B.PREPROCESS_PACKAGE, B.PREPROCESS_API, B.NOTIFICATION_ROLE_CODE, B.NOTIFICATION_TYPE_CODE, B.NOTIFICATION_PROCESS_URL, B.ERROR_NOTIFICATION_ROLE_CODE, B.ERROR_NOTIFICATION_TYPE_CODE, B.ERROR_NOTIFICATION_PROCESS_URL, B.NOTIFICATION_FLAG, B.ENABLED_FLAG, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.RECORD_TYPE_CODE, T.STREAM_TYPE_NAME FROM FUN_STREAM_TYPES_TL T, FUN_STREAM_TYPES_B B WHERE B.STREAM_TYPE_ID = T.STREAM_TYPE_ID AND T.LANGUAGE = USERENV('LANG')