VIEW: APPS.WIP_OSP_OPERATIONS_VAL_V

Source

View Text - Preformatted

SELECT WO.WIP_ENTITY_ID , WO.ORGANIZATION_ID , WO.OPERATION_SEQ_NUM , WO.REPETITIVE_SCHEDULE_ID , BSO.OPERATION_CODE , BD.DEPARTMENT_CODE FROM BOM_DEPARTMENTS BD , BOM_STANDARD_OPERATIONS BSO , WIP_OPERATIONS WO WHERE WO.DEPARTMENT_ID = BD.DEPARTMENT_ID AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+) AND NVL(BSO.OPERATION_TYPE,1) = 1 AND BSO.LINE_ID IS NULL AND EXISTS (SELECT 'LOOKING FOR OSP RESOURCES' FROM WIP_OPERATION_RESOURCES WOR WHERE WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID AND WO.ORGANIZATION_ID = WOR.ORGANIZATION_ID AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM AND NVL(WO.REPETITIVE_SCHEDULE_ID, -1) = NVL(WOR.REPETITIVE_SCHEDULE_ID, -1) AND WOR.AUTOCHARGE_TYPE IN (3, 4))

View Text - HTML Formatted

SELECT WO.WIP_ENTITY_ID
, WO.ORGANIZATION_ID
, WO.OPERATION_SEQ_NUM
, WO.REPETITIVE_SCHEDULE_ID
, BSO.OPERATION_CODE
, BD.DEPARTMENT_CODE
FROM BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BSO
, WIP_OPERATIONS WO
WHERE WO.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND WO.STANDARD_OPERATION_ID = BSO.STANDARD_OPERATION_ID (+)
AND NVL(BSO.OPERATION_TYPE
, 1) = 1
AND BSO.LINE_ID IS NULL
AND EXISTS (SELECT 'LOOKING FOR OSP RESOURCES'
FROM WIP_OPERATION_RESOURCES WOR
WHERE WO.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WOR.ORGANIZATION_ID
AND WO.OPERATION_SEQ_NUM = WOR.OPERATION_SEQ_NUM
AND NVL(WO.REPETITIVE_SCHEDULE_ID
, -1) = NVL(WOR.REPETITIVE_SCHEDULE_ID
, -1)
AND WOR.AUTOCHARGE_TYPE IN (3
, 4))