View: WSM_COPY_NEXT_OPERATIONS_V

Product:	WSM - Shop Floor Management
Description:	View for getting all valid next operations for a Job based on the network routing based on the copy tables of the job based on the copy tables of the job.
Implementation/DBA Data:	APPS.WSM_COPY_NEXT_OPERATIONS_V

View Text

SELECT WCO.WIP_ENTITY_ID
, WO.OPERATION_SEQ_NUM FM_OPERATION_SEQ_NUM
, WO2.OPERATION_SEQ_NUM + NVL(WP.OP_SEQ_NUM_INCREMENT
, 10) TO_WO_OPERATION_SEQ_NUM
, WCO.OPERATION_SEQ_NUM TO_WCO_OPERATION_SEQ_NUM
, WO.OPERATION_SEQUENCE_ID FM_OPERATION_SEQ_ID
, WCO.OPERATION_SEQUENCE_ID TO_OPERATION_SEQ_ID
, BSO.OPERATION_CODE
, WCO.STANDARD_OPERATION_CODE NEXT_OPERATION_CODE
, WCO.OPERATION_DESCRIPTION
, WCO.STANDARD_OPERATION_ID
, WCO.DEPARTMENT_CODE
, WCO.DEPARTMENT_ID
, WCON.RECOMMENDED RECOMMENDED_NEXT_OPERATION
, WCO.RECOMMENDED RECOMMENDED_OPERATION FROM WSM_COPY_OPERATIONS WCO
, WSM_COPY_OP_NETWORKS WCON
, WIP_OPERATIONS WO
, WIP_OPERATIONS WO2
, WSM_PARAMETERS WP
, BOM_STANDARD_OPERATIONS BSO
WHERE WO.WIP_ENTITY_ID = WCO.WIP_ENTITY_ID AND BSO.STANDARD_OPERATION_ID(+) = WO.STANDARD_OPERATION_ID AND WCON.WIP_ENTITY_ID = WCO.WIP_ENTITY_ID AND WCON.FROM_OP_SEQ_ID=WO.OPERATION_SEQUENCE_ID AND WCO.OPERATION_SEQUENCE_ID = WCON.TO_OP_SEQ_ID AND WO.ORGANIZATION_ID = WP.ORGANIZATION_ID AND WO.WIP_ENTITY_ID=WO2.WIP_ENTITY_ID
AND WO2.OPERATION_SEQ_NUM = ( SELECT MAX(OPERATION_SEQ_NUM)
FROM WIP_OPERATIONS
WHERE WIP_ENTITY_ID = WO2.WIP_ENTITY_ID ) UNION SELECT WO.WIP_ENTITY_ID
, WO.OPERATION_SEQ_NUM FM_OPERATION_SEQ_NUM
, WO.OPERATION_SEQ_NUM TO_WO_OPERATION_SEQ_NUM
, BOS.OPERATION_SEQ_NUM TO_WCO_OPERATION_SEQ_NUM
, WO.OPERATION_SEQUENCE_ID FM_OPERATION_SEQ_ID
, BOS.OPERATION_SEQUENCE_ID TO_OPERATION_SEQ_ID
, BSO.OPERATION_CODE
, BSO.OPERATION_CODE NEXT_OPERATION_CODE
, NVL(BSO.OPERATION_DESCRIPTION
, BOS.OPERATION_DESCRIPTION) OPERATION_DESCRIPTION
, WO.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, WO.DEPARTMENT_ID
, TO_CHAR(NULL) RECOMMENDED_NEXT_OPERATION
, TO_CHAR(NULL) RECOMMENDED_OPERATION FROM BOM_OPERATION_SEQUENCES BOS
, BOM_STANDARD_OPERATIONS BSO
, BOM_DEPARTMENTS BD
, WIP_OPERATIONS WO
, WIP_DISCRETE_JOBS WDJ WHERE BOS.OPERATION_SEQUENCE_ID = WO.OPERATION_SEQUENCE_ID
AND BSO.STANDARD_OPERATION_ID(+) = BOS.STANDARD_OPERATION_ID AND WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
AND WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID AND BD.DEPARTMENT_ID = BOS.DEPARTMENT_ID

Columns