View: WIP_ACTIVE_DISCRETE_JOBS_VAL_V

Product:	WIP - Work in Process
Description:	Active discrete jobs
Implementation/DBA Data:	APPS.WIP_ACTIVE_DISCRETE_JOBS_VAL_V

View Text

SELECT J.WIP_ENTITY_ID
, E.WIP_ENTITY_NAME
, J.DESCRIPTION
, J.ORGANIZATION_ID
, E.ENTITY_TYPE
, J.JOB_TYPE
, J.SCHEDULED_START_DATE
, J.SCHEDULED_COMPLETION_DATE
, J.PRIMARY_ITEM_ID
, J.STATUS_TYPE
, J.START_QUANTITY
, J.BOM_REVISION
, J.COMPLETION_SUBINVENTORY
, J.COMPLETION_LOCATOR_ID
, J.LOT_NUMBER JOB_LOT_NUMBER
FROM WIP_ENTITIES E
, WIP_DISCRETE_JOBS J
WHERE E.WIP_ENTITY_ID = J.WIP_ENTITY_ID
AND J.STATUS_TYPE IN (3
, 4
, 6)

Columns