View: WSM_COPY_ALL_OPERATIONS_V

Product:	WSM - Shop Floor Management
Description:	View for getting all standard operations in an OSFM org
Implementation/DBA Data:	APPS.WSM_COPY_ALL_OPERATIONS_V

View Text

SELECT WCO.WIP_ENTITY_ID
, 10 TO_OP_SEQ_NUM
, WCO.OPERATION_SEQ_NUM TO_WCO_OP_SEQ_NUM
, WCO.OPERATION_SEQUENCE_ID TO_OP_SEQ_ID
, WCO.STANDARD_OPERATION_CODE NEXT_OPERATION_CODE
, WCO.OPERATION_DESCRIPTION
, WCO.STANDARD_OPERATION_ID
, WCO.DEPARTMENT_CODE
, WCO.DEPARTMENT_ID
, WCO.RECOMMENDED FROM WSM_COPY_OPERATIONS WCO
, WSM_COPY_OP_NETWORKS WCON
WHERE WCO.WIP_ENTITY_ID=WCON.WIP_ENTITY_ID AND ((WCO.OPERATION_SEQ_NUM = WCON.FROM_OP_SEQ_NUM) OR (WCO.OPERATION_SEQ_NUM = WCON.TO_OP_SEQ_NUM))

Columns