VIEW: APPS.BOMBV_OPERATION_NETWORKS

Source

View Text - Preformatted

SELECT '_KF:INV:MSTK:SYS1' "_KF:ROUTING_FROM_ITEM_NAME" , '_KF:INV:MSTK:SYS2' "_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

View Text - HTML Formatted

SELECT '_KF:INV:MSTK:SYS1' "_KF:ROUTING_FROM_ITEM_NAME"
, '_KF:INV:MSTK:SYS2' "_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