FUN_STREAM_TYPE_STEPS_VL

Details

• Schema: FUSION

• Object owner: FUN

• Object type: VIEW

Columns

Name

STREAM_TYPE_STEP_ID STREAM_TYPE_ID STREAM_TYPE_STEP_CODE STEP_PROCESS_TYPE_CODE STEP_PROCESS_NAME PROCESS_EXECUTION_TYPE_CODE PROGRAM_TYPE SEQUENCE NOTIFICATION_ROLE_CODE NOTIFICATION_TYPE_CODE NOTIFICATION_PROCESS_URL ERROR_NOTIFICATION_ROLE_CODE ERROR_NOTIFICATION_TYPE_CODE ERROR_NOTIFICATION_PROCESS_URL NOTIFICATION_FLAG PREPROCESS_TYPE_CODE PREPROCESS_PACKAGE PREPROCESS_API ENABLED_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN RECORD_TYPE_CODE STEP_TYPE_OPERATION STEP_TYPE_NAME

Query

SQL_Statement

SELECT B.STREAM_TYPE_STEP_ID, B.STREAM_TYPE_ID, B.STREAM_TYPE_STEP_CODE, B.STEP_PROCESS_TYPE_CODE, B.STEP_PROCESS_NAME, B.PROCESS_EXECUTION_TYPE_CODE, B.PROGRAM_TYPE , B.SEQUENCE, 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.PREPROCESS_TYPE_CODE, B.PREPROCESS_PACKAGE, B.PREPROCESS_API, 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, B.STEP_TYPE_OPERATION, T.STEP_TYPE_NAME FROM FUN_STREAM_TYPE_STEPS_TL T, FUN_STREAM_TYPE_STEPS_B B WHERE B.STREAM_TYPE_STEP_ID = T.STREAM_TYPE_STEP_ID AND T.LANGUAGE = USERENV('LANG')