VIEW: APPS.POR_WIP_ENTITY_NAME_LOV_V

Source

View Text - Preformatted

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) )

View Text - HTML Formatted

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) )