Hello Dear Community Users,

I have a question regarding the following topic.

I need to add the current operation state and the state of the operation before the current operation as parameters. When the parameter popup window is opened, 2 pieces of operation status (Oper Status Code) field are displayed. Which one is present and which previous operation parameter is not understood. 

SELECT *
  FROM shop_order_operation o
  LEFT JOIN shop_order_operation prev_op
	ON prev_op.order_no = o.order_no AND
	   prev_op.release_no = o.release_no AND
	   prev_op.sequence_no = o.sequence_no AND
	   prev_op.operation_no = shop_order_operation_api.get_previous_operation(o.order_no, o.release_no, o.sequence_no, o.operation_no)
 WHERE 
o.work_center_no = '&mMCS-L]Work_Center_No' AND
o.oper_status_code = '&mMCS-L]shop_order_operation.oper_status_code' AND
prev_op.oper_status_code = '&mMCS-L]operation_history.oper_status_code';

How do we make special prompt when we use view column which is enumeration?

Best Regards,

Barış