VIEW: APPS.POR_OPERATION_SEQ_NUM_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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