View: WIP_JOBS_RESERVATIONS_V

Product:	WIP - Work in Process
Description:	Data for Jobs eligible for reservations
Implementation/DBA Data:	APPS.WIP_JOBS_RESERVATIONS_V

View Text

SELECT WDJ.WIP_ENTITY_ID
, WE.WIP_ENTITY_NAME
, WDJ.DESCRIPTION
, WDJ.ORGANIZATION_ID
, WE.ENTITY_TYPE
, WDJ.JOB_TYPE
, WDJ.SCHEDULED_START_DATE
, WDJ.SCHEDULED_COMPLETION_DATE
, WDJ.PRIMARY_ITEM_ID
, WDJ.STATUS_TYPE
, WDJ.START_QUANTITY
, WDJ.NET_QUANTITY
, WDJ.BOM_REVISION
, WDJ.COMPLETION_SUBINVENTORY
, WDJ.COMPLETION_LOCATOR_ID
, WDJ.LOT_NUMBER JOB_LOT_NUMBER
, WDJ.PROJECT_ID
, WDJ.TASK_ID
, WDJ.SERIALIZATION_START_OP
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND ((START_QUANTITY - QUANTITY_SCRAPPED - QUANTITY_COMPLETED) > ( SELECT SUM(PRIMARY_QUANTITY)
FROM WIP_RESERVATIONS_V WRV
WHERE WRV.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID GROUP BY WIP_ENTITY_ID ) OR NOT EXISTS (SELECT 'X'
FROM WIP_RESERVATIONS_V WRV
WHERE WRV.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID ) OR EXISTS (SELECT MTRL.PRIMARY_QUANTITY
FROM MTL_TXN_REQUEST_LINES MTRL
, WMS_LICENSE_PLATE_NUMBERS WLPN
WHERE MTRL.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND MTRL.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND NVL(MTRL.QUANTITY_DELIVERED
, 0) = 0
AND MTRL.TXN_SOURCE_ID = WDJ.WIP_ENTITY_ID
AND MTRL.LPN_ID = WLPN.LPN_ID
AND WLPN.LPN_CONTEXT = 2
AND MTRL.LINE_STATUS <> 5 ) )
AND ((EXISTS (SELECT MTRL.PRIMARY_QUANTITY
FROM MTL_TXN_REQUEST_LINES MTRL
, WMS_LICENSE_PLATE_NUMBERS WLPN
WHERE MTRL.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND MTRL.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND NVL(MTRL.QUANTITY_DELIVERED
, 0) = 0
AND MTRL.TXN_SOURCE_ID = WDJ.WIP_ENTITY_ID
AND MTRL.LPN_ID = WLPN.LPN_ID
AND WLPN.LPN_CONTEXT = 2
AND MTRL.LINE_STATUS <> 5 )
AND WDJ.STATUS_TYPE IN (1
, 3
, 4
, 6) ) OR WDJ.STATUS_TYPE IN (1
, 3
, 6))

Columns