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' |