View: WIP_OSP_OPERATIONS_VAL_V

Product:	WIP - Work in Process
Description:	Operations with outside processing resources
Implementation/DBA Data:	APPS.WIP_OSP_OPERATIONS_VAL_V

View Text

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

Columns