Learn Oracle ebs R12: 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;