This content has been marked as final. Show 2 replies
Wip_entity_name is the work order number.
Wip_entity_id is a behind-the-scenes id that is used by Oracle to join other wip tables.
You can get the work order type by using the following sql.
Hope this helps,
SELECT lookup_code, meaning FROM fnd_lookup_values WHERE lookup_type LIKE 'WIP_EAM_WORK_ORDER_TYPE'
thanks for your reply, that has really helped.