View: WSM_ALL_OPERATIONS_V

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

View Text

SELECT /* ALL THE OPERATIONS IN BON */ WDJ.WIP_ENTITY_ID
, 10
, BOS.OPERATION_SEQ_NUM
, BOS.OPERATION_SEQUENCE_ID
, BSO.OPERATION_CODE
, BOS.OPERATION_DESCRIPTION
, BOS.STANDARD_OPERATION_ID
, BD.DEPARTMENT_CODE
, BOS.DEPARTMENT_ID
FROM BOM_OPERATION_SEQUENCES BOS
, BOM_STANDARD_OPERATIONS BSO
, BOM_OPERATIONAL_ROUTINGS BOR
, BOM_OPERATION_NETWORKS BON
, BOM_DEPARTMENTS BD
, WIP_DISCRETE_JOBS WDJ
WHERE /* BC: CZH: I_OED-2 */ /* CZH: REMOVE CALLING WSMPUTIL.REPLACEMENT_OP_SEQ_ID ( NVL(WSMPUTIL.REPLACEMENT_OP_SEQ_ID(BON.FROM_OP_SEQ_ID
, WDJ.ROUTING_REVISION_DATE)
, -1) = BOS.OPERATION_SEQUENCE_ID OR NVL(WSMPUTIL.REPLACEMENT_OP_SEQ_ID(BON.TO_OP_SEQ_ID
, WDJ.ROUTING_REVISION_DATE)
, -1) = BOS.OPERATION_SEQUENCE_ID ) */ ( BON.FROM_OP_SEQ_ID IN ( SELECT B.OPERATION_SEQUENCE_ID
FROM BOM_OPERATION_SEQUENCES B
, BOM_OPERATION_SEQUENCES B2
WHERE B.OPERATION_SEQ_NUM = B2.OPERATION_SEQ_NUM
AND B.ROUTING_SEQUENCE_ID = B2.ROUTING_SEQUENCE_ID
AND B2.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID ) OR BON.TO_OP_SEQ_ID IN ( SELECT B.OPERATION_SEQUENCE_ID
FROM BOM_OPERATION_SEQUENCES B
, BOM_OPERATION_SEQUENCES B2
WHERE B.OPERATION_SEQ_NUM = B2.OPERATION_SEQ_NUM
AND B.ROUTING_SEQUENCE_ID = B2.ROUTING_SEQUENCE_ID
AND B2.OPERATION_SEQUENCE_ID = BOS.OPERATION_SEQUENCE_ID ) ) /* EC: CZH: I_OED-2 */
AND BSO.STANDARD_OPERATION_ID(+) = BOS.STANDARD_OPERATION_ID
AND BD.DEPARTMENT_ID = BOS.DEPARTMENT_ID
AND BOS.ROUTING_SEQUENCE_ID = NVL(BOR.COMMON_ROUTING_SEQUENCE_ID
, BOR.ROUTING_SEQUENCE_ID)
AND BOS.ROUTING_SEQUENCE_ID = WDJ.COMMON_ROUTING_SEQUENCE_ID
AND BOR.ASSEMBLY_ITEM_ID = DECODE(WDJ.JOB_TYPE
, 1
, WDJ.PRIMARY_ITEM_ID
, WDJ.ROUTING_REFERENCE_ID)
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) >= NVL(BOS.EFFECTIVITY_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE))
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) <= NVL(BOS.DISABLE_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE)+1)
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) >= NVL(BON.EFFECTIVITY_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE))
AND NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE) <= NVL(BON.DISABLE_DATE
, NVL(WDJ.ROUTING_REVISION_DATE
, SYSDATE)+1)

Columns