View: POR_WIP_ENTITY_NAME_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of values for work order
Implementation/DBA Data:	APPS.POR_WIP_ENTITY_NAME_LOV_V

View Text

SELECT WE.WIP_ENTITY_NAME
, WE.DESCRIPTION
, PPEV.PROJECT_NUMBER
, PTEV.TASK_NUMBER
FROM WIP_DISCRETE_JOBS WDJ
, WIP_ENTITIES WE
, PA_PROJECTS_EXPEND_V PPEV
, PA_TASKS_EXPEND_V PTEV
WHERE WDJ.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WE.ENTITY_TYPE = 6
AND WDJ.STATUS_TYPE IN (3
, 4
, 6)
AND WDJ.PROJECT_ID = PPEV.PROJECT_ID (+)
AND WDJ.TASK_ID = PTEV.TASK_ID (+)
AND WE.ORGANIZATION_ID IN (SELECT OOD.ORGANIZATION_ID
FROM ORG_ORGANIZATION_DEFINITIONS OOD
WHERE OOD.OPERATING_UNIT = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99) )

Columns