VIEW: APPS.WIP_DISCRETE_JOBS_ALL_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 FROM WIP_ENTITIES E , WIP_DISCRETE_JOBS J WHERE E.WIP_ENTITY_ID = J.WIP_ENTITY_ID

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
FROM WIP_ENTITIES E
, WIP_DISCRETE_JOBS J
WHERE E.WIP_ENTITY_ID = J.WIP_ENTITY_ID