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 DISTINCT 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
, BR.PURCHASE_ITEM_ID
FROM WIP_ENTITIES WE
, WIP_DISCRETE_JOBS WDJ
, WIP_OPERATION_RESOURCES WOR
, BOM_RESOURCES BR
WHERE WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE IN (3
, 4
, 6)
AND WDJ.ORGANIZATION_ID = WOR.ORGANIZATION_ID
AND WDJ.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
AND WOR.RESOURCE_ID = BR.RESOURCE_ID
AND WOR.AUTOCHARGE_TYPE IN (3
, 4)

Columns