ZCA_ORCH_DT_VL

Details

• Schema: FUSION

• Object owner: ZCA

• Object type: VIEW

Columns

Name

ORCHESTRATION_ID ORCHESTRATION_NUMBER ORCHESTRATION_NAME ORCHESTRATION_DESC_TEXT OBJECT_CODE STRIPING_ATTR_NAME STRIPING_ATTR_DISPLAY_LABEL STRIPING_ATTR_VALUE LIFECYCLE_ATTR_NAME LIFECYCLE_ATTR_DISPLAY_LABEL ASSOCIATION_CRITERIA_EXPR ORCHESTRATION_JSON_STRUCTURE ORCHESTRATION_TYPE SOURCE_ORCHESTRATION_ID STATUS_CODE ASSOCIATION_RANK ACTIVATION_DATETIME IMPORTED_DATETIME SIMULATION_CRITERIA_EXPR ACTIVITY_RELATION_ATTR_NAME 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_ID, B.ORCHESTRATION_NUMBER, T.ORCHESTRATION_NAME, T.ORCHESTRATION_DESC_TEXT, B.OBJECT_CODE, B.STRIPING_ATTR_NAME, B.STRIPING_ATTR_DISPLAY_LABEL, B.STRIPING_ATTR_VALUE, B.LIFECYCLE_ATTR_NAME, B.LIFECYCLE_ATTR_DISPLAY_LABEL, B.ASSOCIATION_CRITERIA_EXPR, B.ORCHESTRATION_JSON_STRUCTURE, B.ORCHESTRATION_TYPE, B.SOURCE_ORCHESTRATION_ID, B.STATUS_CODE, B.ASSOCIATION_RANK, B.ACTIVATION_DATETIME, B.IMPORTED_DATETIME, B.SIMULATION_CRITERIA_EXPR, B.ACTIVITY_RELATION_ATTR_NAME, 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 ZCA_ORCH_DT_B B, ZCA_ORCH_DT_TL T WHERE B.ORCHESTRATION_ID = T.ORCHESTRATION_ID AND T.LANGUAGE = USERENV('LANG')