CST_WD_OP_DEPENDENCIES_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name
SCENARIO_ID WORK_DEFINITION_ITEM_ID SUCCESSOR_CST_OPERATION_ID SUCCESSOR_WD_OPERATION_ID OP_YIELD_FACTOR OP_CUM_YIELD_FACTOR OP_REV_YIELD_FACTOR CALCULATION_SEQUENCE DEPENDENCY_TYPE TRANSFER_PERCENT

Query

SQL_Statement

SELECT cwod.scenario_id, cwod.work_definition_item_id, cwod.successor_cst_operation_id, cwod.successor_wd_operation_id, MAX(cwod.op_yield_factor) op_yield_factor, MAX(cwod.op_cum_yield_factor) op_cum_yield_factor, MAX(cwod.op_rev_yield_factor) op_rev_yield_factor, MAX(cwod.calculation_sequence) calculation_sequence, MAX(cwod.dependency_type) dependency_type, MAX(cwod.transfer_percent) transfer_percent FROM cst_wd_op_dependencies cwod GROUP BY cwod.scenario_id, cwod.work_definition_item_id, cwod.successor_cst_operation_id, cwod.successor_wd_operation_id