View: POR_OPERATION_SEQ_NUM_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of values for operation reference
Implementation/DBA Data:	APPS.POR_OPERATION_SEQ_NUM_LOV_V

View Text

SELECT WO.OPERATION_SEQ_NUM
, BSO.OPERATION_CODE
, BD.DEPARTMENT_CODE
, WE.WIP_ENTITY_NAME
FROM WIP_OPERATIONS WO
, WIP_ENTITIES WE
, BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO
WHERE WO.WIP_ENTITY_ID = WE.WIP_ENTITY_ID
AND WE.ENTITY_TYPE = 6
AND WO.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)
AND NVL(BSO.OPERATION_TYPE
, 1) = 1
AND WO.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