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

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