ZCA_ORCH_DT_STEPS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: ZCA
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CONFLICT_ID USER_LAST_UPDATE_DATE |
問合せ
| 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.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') |