[Home] [Help]
View: 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
Name |
OPERATION_SEQ_NUM |
OPERATION_CODE |
DEPARTMENT_CODE |
WIP_ENTITY_NAME |