WIP_DISCRETE_JOBS.STATUS_TYPE values in Oracle WIP ( work in process)

The following lookup table can be query to find the status_type of a discrete job in oracle applications discrete manufacturing work in process.

SELECT *
FROM apps.fnd_lookup_values
WHERE lookup_type LIKE ‘%WIP_JOB_STATUS%’

SELECT status_type FROM wip_discrete_jobs WHERE wip_entity_id = 1743670;

 

Value Meaning
7 Cancelled
8 Pending Bill Load
9 Failed Bill Load
10 Pending Routing Load
11 Failed Routing Load
12 Closed
13 Pending – Mass Loaded
14 Pending Close
15 Failed Close
1 Unreleased
3 Released
4 Complete
5 Complete – No Charges
6 On Hold