View: BOMBV_OPERATION_NETWORKS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMBV_OPERATION_NETWORKS

View Text

SELECT '_KF:INV:MSTK:SY1' "_KF:ROUTING_FROM_ITEM_NAME"
, '_KF:INV:MSTK:SY2' "_KF:ROUTING_TO_ITEM_NAME"
, SQ1.OPERATION_SEQ_NUM FROM_OPERATION_SEQ_NUM
, SQ1.EFFECTIVITY_DATE FROM_EFFECTIVITY_DATE
, SQ2.OPERATION_SEQ_NUM TO_OPERATION_SEQ_NUM
, SQ2.EFFECTIVITY_DATE TO_EFFECTIVITY_DATE
, OP1.ALTERNATE_ROUTING_DESIGNATOR FROM_ALTERNATE_ROUTING_CODE
, OP2.ALTERNATE_ROUTING_DESIGNATOR TO_ALTERNATE_ROUTING_CODE
, PA1.ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, AL1.NAME FROM_ORGANIZATION_NAME
, PA2.ORGANIZATION_CODE TO_ORGANIZATION_CODE
, AL2.NAME TO_ORGANIZATION_NAME
, NE.TRANSITION_TYPE CONNECTION_TYPE
, NE.PLANNING_PCT PLANNING_PERCENT
, NE.EFFECTIVITY_DATE START_EFFECTIVE_DATE
, NE.DISABLE_DATE END_EFFECTIVE_DATE
, OP1.ROUTING_SEQUENCE_ID FROM_ROUTING_SEQUENCE_ID
, OP2.ROUTING_SEQUENCE_ID TO_ROUTING_SEQUENCE_ID
, NE.FROM_OP_SEQ_ID
, NE.TO_OP_SEQ_ID
, NE.LAST_UPDATE_DATE
, NE.LAST_UPDATED_BY
, NE.CREATION_DATE
, NE.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL2
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA2
, MTL_PARAMETERS PA1
, MTL_SYSTEM_ITEMS_B SYS2
, MTL_SYSTEM_ITEMS_B SYS1
, BOM_OPERATIONAL_ROUTINGS OP2
, BOM_OPERATIONAL_ROUTINGS OP1
, BOM_OPERATION_SEQUENCES SQ2
, BOM_OPERATION_SEQUENCES SQ1
, BOM_OPERATION_NETWORKS NE
WHERE PA1.ORGANIZATION_ID = OP1.ORGANIZATION_ID
AND PA2.ORGANIZATION_ID = OP2.ORGANIZATION_ID
AND AL1.ORGANIZATION_ID = OP1.ORGANIZATION_ID
AND AL2.ORGANIZATION_ID = OP2.ORGANIZATION_ID
AND OP1.ASSEMBLY_ITEM_ID = SYS1.INVENTORY_ITEM_ID
AND OP1.ORGANIZATION_ID = SYS1.ORGANIZATION_ID
AND OP2.ASSEMBLY_ITEM_ID = SYS2.INVENTORY_ITEM_ID
AND OP2.ORGANIZATION_ID = SYS2.ORGANIZATION_ID
AND SQ1.ROUTING_SEQUENCE_ID = OP1.ROUTING_SEQUENCE_ID
AND SQ2.ROUTING_SEQUENCE_ID = OP2.ROUTING_SEQUENCE_ID
AND NE.FROM_OP_SEQ_ID = SQ1.OPERATION_SEQUENCE_ID
AND NE.TO_OP_SEQ_ID = SQ2.OPERATION_SEQUENCE_ID WITH READ ONLY

Columns