ZCA_ORCH_DT_STEPS_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name

ORCHESTRATION_STEP_ID ORCHESTRATION_STEP_NUMBER ORCHESTRATION_STEP_NAME STEP_SUGGESTION_TEXT ORCHESTRATION_STAGE_ID STEP_TYPE EXECUTION_METHOD DISPLAY_SEQUENCE ACTIVITY_TEMPLATE_ID SMART_ACTION_ID EMAIL_TEMPLATE_ID SUCCESS_STEP_ID SUCCESS_CRITERIA FAILURE_STEP_ID DAYS_TO_WAIT NEXT_STAGE_VALUE HOURS_TO_WAIT IA_TEMPLATE_VALUE FIELD_UPDATE_JSON GRACE_PERIOD WAIT_FOR_REPLIES_FLAG EMAIL_CONTACTS_FILTER_CRITERIA EMAIL_CONTS_OBJECT_CD EXIT_ORCHESTRATION_FLAG ALLOW_SKIP_FLAG EVALUATE_ON_MARKCOMPLETE_FLAG PRE_STEP_CONDITION CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CONFLICT_ID USER_LAST_UPDATE_DATE

Query

SQL_Statement

SELECT B.ORCHESTRATION_STEP_ID, B.ORCHESTRATION_STEP_NUMBER, T.ORCHESTRATION_STEP_NAME, T.STEP_SUGGESTION_TEXT, B.ORCHESTRATION_STAGE_ID, B.STEP_TYPE, B.EXECUTION_METHOD, B.DISPLAY_SEQUENCE, B.ACTIVITY_TEMPLATE_ID, B.SMART_ACTION_ID, B.EMAIL_TEMPLATE_ID, B.SUCCESS_STEP_ID, B.SUCCESS_CRITERIA, B.FAILURE_STEP_ID, B.DAYS_TO_WAIT, B.NEXT_STAGE_VALUE, B.HOURS_TO_WAIT, B.IA_TEMPLATE_VALUE, B.FIELD_UPDATE_JSON, B.GRACE_PERIOD, B.WAIT_FOR_REPLIES_FLAG, B.EMAIL_CONTACTS_FILTER_CRITERIA, B.EMAIL_CONTS_OBJECT_CD, B.EXIT_ORCHESTRATION_FLAG, B.ALLOW_SKIP_FLAG, B.EVALUATE_ON_MARKCOMPLETE_FLAG, B.PRE_STEP_CONDITION, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.CONFLICT_ID, B.USER_LAST_UPDATE_DATE FROM FUSION.ZCA_ORCH_DT_STEPS_B B, FUSION.ZCA_ORCH_DT_STEPS_TL T WHERE B.ORCHESTRATION_STEP_ID = T.ORCHESTRATION_STEP_ID AND T.LANGUAGE = USERENV('LANG')