VIEW: APPS.WIP_OPEN_DISCRETE_JOBS_VAL_V

Source

View Text - Preformatted

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 , J.PROJECT_ID , J.TASK_ID , J.SERIALIZATION_START_OP FROM WIP_ENTITIES E , WIP_DISCRETE_JOBS J WHERE E.WIP_ENTITY_ID = J.WIP_ENTITY_ID AND J.STATUS_TYPE IN (1, 3, 4, 6)

View Text - HTML Formatted

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
, J.PROJECT_ID
, J.TASK_ID
, J.SERIALIZATION_START_OP
FROM WIP_ENTITIES E
, WIP_DISCRETE_JOBS J
WHERE E.WIP_ENTITY_ID = J.WIP_ENTITY_ID
AND J.STATUS_TYPE IN (1
, 3
, 4
, 6)