VIEW: APPS.BOM_OPERATION_NETWORKS_V

Source

View Text - Preformatted

SELECT BON.ROWID ROW_ID , BOS1.ROUTING_SEQUENCE_ID , BON.FROM_OP_SEQ_ID , BOS1.OPERATION_SEQ_NUM FROM_SEQ_NUM , BSO1.OPERATION_CODE FROM_OPERATION_CODE , BOS1.EFFECTIVITY_DATE FROM_EFFECTIVITY_DATE , DECODE(NVL(BOS1.STANDARD_OPERATION_ID,0),0,BOS1.OPERATION_DESCRIPTION,BSO1.OPERATION_DESCRIPTION) FROM_OPERATION_DESC , BD1.DEPARTMENT_CODE FROM_DEPT_CODE , BON.TO_OP_SEQ_ID , BOS2.OPERATION_SEQ_NUM TO_SEQ_NUM , BSO2.OPERATION_CODE TO_OPERATION_CODE , BOS2.EFFECTIVITY_DATE TO_EFFECTIVITY_DATE , DECODE(NVL(BOS2.STANDARD_OPERATION_ID,0),0,BOS2.OPERATION_DESCRIPTION,BSO2.OPERATION_DESCRIPTION) TO_OPERATION_DESC , BD2.DEPARTMENT_CODE TO_DEPT_CODE , BON.TRANSITION_TYPE , BON.PLANNING_PCT , BON.CREATION_DATE , BON.CREATED_BY , BON.LAST_UPDATE_DATE , BON.LAST_UPDATE_LOGIN , BON.LAST_UPDATED_BY , BON.ATTRIBUTE_CATEGORY , BON.ATTRIBUTE1 , BON.ATTRIBUTE2 , BON.ATTRIBUTE3 , BON.ATTRIBUTE4 , BON.ATTRIBUTE5 , BON.ATTRIBUTE6 , BON.ATTRIBUTE7 , BON.ATTRIBUTE8 , BON.ATTRIBUTE9 , BON.ATTRIBUTE10 , BON.ATTRIBUTE11 , BON.ATTRIBUTE12 , BON.ATTRIBUTE13 , BON.ATTRIBUTE14 , BON.ATTRIBUTE15 , bos1.operation_type operation_type , BON.ORIGINAL_SYSTEM_REFERENCE FROM BOM_STANDARD_OPERATIONS BSO2, BOM_OPERATION_SEQUENCES BOS2 , BOM_STANDARD_OPERATIONS BSO1, BOM_OPERATION_SEQUENCES BOS1, BOM_DEPARTMENTS BD1, BOM_DEPARTMENTS BD2, BOM_OPERATION_NETWORKS BON WHERE BON.FROM_OP_SEQ_ID = BOS1.OPERATION_SEQUENCE_ID AND BSO1.STANDARD_OPERATION_ID(+) = WSMPUTIL.get_eff_stdop_id(BOS1.STANDARD_OPERATION_ID, BOS1.OPERATION_SEQUENCE_ID) AND BD1.DEPARTMENT_ID = WSMPUTIL.get_eff_dept_id(BOS1.DEPARTMENT_ID,BOS1.OPERATION_SEQUENCE_ID) AND BON.TO_OP_SEQ_ID = BOS2.OPERATION_SEQUENCE_ID AND BSO2.STANDARD_OPERATION_ID (+) = WSMPUTIL.get_eff_stdop_id(BOS2.STANDARD_OPERATION_ID,BOS2.OPERATION_SEQUENCE_ID) AND BD2.DEPARTMENT_ID = WSMPUTIL.get_eff_dept_id(BOS2.DEPARTMENT_ID,BOS2.OPERATION_SEQUENCE_ID)

View Text - HTML Formatted

SELECT BON.ROWID ROW_ID
, BOS1.ROUTING_SEQUENCE_ID
, BON.FROM_OP_SEQ_ID
, BOS1.OPERATION_SEQ_NUM FROM_SEQ_NUM
, BSO1.OPERATION_CODE FROM_OPERATION_CODE
, BOS1.EFFECTIVITY_DATE FROM_EFFECTIVITY_DATE
, DECODE(NVL(BOS1.STANDARD_OPERATION_ID
, 0)
, 0
, BOS1.OPERATION_DESCRIPTION
, BSO1.OPERATION_DESCRIPTION) FROM_OPERATION_DESC
, BD1.DEPARTMENT_CODE FROM_DEPT_CODE
, BON.TO_OP_SEQ_ID
, BOS2.OPERATION_SEQ_NUM TO_SEQ_NUM
, BSO2.OPERATION_CODE TO_OPERATION_CODE
, BOS2.EFFECTIVITY_DATE TO_EFFECTIVITY_DATE
, DECODE(NVL(BOS2.STANDARD_OPERATION_ID
, 0)
, 0
, BOS2.OPERATION_DESCRIPTION
, BSO2.OPERATION_DESCRIPTION) TO_OPERATION_DESC
, BD2.DEPARTMENT_CODE TO_DEPT_CODE
, BON.TRANSITION_TYPE
, BON.PLANNING_PCT
, BON.CREATION_DATE
, BON.CREATED_BY
, BON.LAST_UPDATE_DATE
, BON.LAST_UPDATE_LOGIN
, BON.LAST_UPDATED_BY
, BON.ATTRIBUTE_CATEGORY
, BON.ATTRIBUTE1
, BON.ATTRIBUTE2
, BON.ATTRIBUTE3
, BON.ATTRIBUTE4
, BON.ATTRIBUTE5
, BON.ATTRIBUTE6
, BON.ATTRIBUTE7
, BON.ATTRIBUTE8
, BON.ATTRIBUTE9
, BON.ATTRIBUTE10
, BON.ATTRIBUTE11
, BON.ATTRIBUTE12
, BON.ATTRIBUTE13
, BON.ATTRIBUTE14
, BON.ATTRIBUTE15
, BOS1.OPERATION_TYPE OPERATION_TYPE
, BON.ORIGINAL_SYSTEM_REFERENCE
FROM BOM_STANDARD_OPERATIONS BSO2
, BOM_OPERATION_SEQUENCES BOS2
, BOM_STANDARD_OPERATIONS BSO1
, BOM_OPERATION_SEQUENCES BOS1
, BOM_DEPARTMENTS BD1
, BOM_DEPARTMENTS BD2
, BOM_OPERATION_NETWORKS BON
WHERE BON.FROM_OP_SEQ_ID = BOS1.OPERATION_SEQUENCE_ID
AND BSO1.STANDARD_OPERATION_ID(+) = WSMPUTIL.GET_EFF_STDOP_ID(BOS1.STANDARD_OPERATION_ID
, BOS1.OPERATION_SEQUENCE_ID)
AND BD1.DEPARTMENT_ID = WSMPUTIL.GET_EFF_DEPT_ID(BOS1.DEPARTMENT_ID
, BOS1.OPERATION_SEQUENCE_ID)
AND BON.TO_OP_SEQ_ID = BOS2.OPERATION_SEQUENCE_ID
AND BSO2.STANDARD_OPERATION_ID (+) = WSMPUTIL.GET_EFF_STDOP_ID(BOS2.STANDARD_OPERATION_ID
, BOS2.OPERATION_SEQUENCE_ID)
AND BD2.DEPARTMENT_ID = WSMPUTIL.GET_EFF_DEPT_ID(BOS2.DEPARTMENT_ID
, BOS2.OPERATION_SEQUENCE_ID)