View: BOM_OPERATION_NETWORKS_V

Product:	BOM - Bills of Material
Description:	Operation networks view
Implementation/DBA Data:	APPS.BOM_OPERATION_NETWORKS_V

View Text

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 /*
, BOS1.OPERATION_DESCRIPTION FROM_OPERATION_DESC MODIFIED FOR BUGFIX 7387499 */
, 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 /*
, BOS2.OPERATION_DESCRIPTION TO_OPERATION_DESC MODIFIED FOR BUGFIX 7387499*/
, 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 BOS1.STANDARD_OPERATION_ID = BSO1.STANDARD_OPERATION_ID(+) BUGFIX 7387499
AND BD1.DEPARTMENT_ID = BOS1.DEPARTMENT_ID BUGFIX 7387499 */
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 BOS2.STANDARD_OPERATION_ID = BSO2.STANDARD_OPERATION_ID(+) BUGFIX 7387499
AND BD2.DEPARTMENT_ID = BOS2.DEPARTMENT_ID BUGFIX 7387499 */
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)

Columns