VIEW: APPS.WIP_OPERATIONS_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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