View: WIP_OPERATIONS_ALL_V

Product:	WIP - Work in Process
Description:	Summary operation data
Implementation/DBA Data:	APPS.WIP_OPERATIONS_ALL_V

View Text

SELECT WO.OPERATION_SEQ_NUM
, BS.OPERATION_CODE
, WO.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, WO.DEPARTMENT_ID
, WO.FIRST_UNIT_START_DATE
, WO.FIRST_UNIT_COMPLETION_DATE
, WO.LAST_UNIT_START_DATE
, WO.LAST_UNIT_COMPLETION_DATE
, WO.PREVIOUS_OPERATION_SEQ_NUM
, WO.NEXT_OPERATION_SEQ_NUM
, WO.COUNT_POINT_TYPE
, WO.WIP_ENTITY_ID
, WO.ORGANIZATION_ID
, WO.REPETITIVE_SCHEDULE_ID
FROM BOM_DEPARTMENTS BD
, BOM_STANDARD_OPERATIONS BS
, WIP_OPERATIONS WO
WHERE WO.DEPARTMENT_ID = BD.DEPARTMENT_ID
AND WO.STANDARD_OPERATION_ID = BS.STANDARD_OPERATION_ID (+)
AND BS.LINE_ID IS NULL
AND NVL(BS.OPERATION_TYPE
, 1) = 1

Columns