WIE_WO_OP_YIELD_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
WO_OPERATION_ID OPERATION_SEQ_NUMBER WORK_ORDER_ID OP_YIELD_FACTOR CUMULATIVE_YIELD REVERSE_CUMULATIVE_YIELD

Query

SQL_Statement

SELECT wo_operation_id, operation_seq_number, work_order_id, op_yield_factor, round(exp(SUM(ln(op_yield_factor)) OVER(PARTITION BY work_order_id ORDER BY operation_seq_number)), fnd_profile.value('INV_QUANTITY_DECIMAL_PRECISION')) cumulative_yield, round(exp(SUM(ln(op_yield_factor)) OVER(PARTITION BY work_order_id ORDER BY operation_seq_number DESC)), fnd_profile.value('INV_QUANTITY_DECIMAL_PRECISION')) reverse_cumulative_yield FROM wie_wo_operations_b WHERE operation_type = 'IN_HOUSE' AND count_point_operation_flag = 'Y'