View: WIP_OSP_JOBS_VAL_V

Product:	WIP - Work in Process
Description:	Active jobs with outside processing resources
Implementation/DBA Data:	APPS.WIP_OSP_JOBS_VAL_V

View Text

SELECT WE.WIP_ENTITY_NAME
, WDJ.DESCRIPTION
, WDJ.WIP_ENTITY_ID
, WDJ.PRIMARY_ITEM_ID
, WDJ.ORGANIZATION_ID
, WE.ENTITY_TYPE
, WDJ.PROJECT_ID
, WDJ.TASK_ID
FROM WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE IN (3
, 4
, 6)
AND EXISTS (SELECT 'LOOKING FOR OSP RESOURCES'
FROM WIP_OPERATION_RESOURCES WOR
WHERE WDJ.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
AND WDJ.ORGANIZATION_ID = WOR.ORGANIZATION_ID
AND WOR.AUTOCHARGE_TYPE IN (3
, 4))

Columns