APPS.BOM_VALIDATE_OP_NETWORK dependencies on BOM_OPERATION_NETWORKS

Line 793: FROM bom_operation_networks a

789: SELECT 'x' dummy
790: FROM DUAL
791: WHERE EXISTS
792: ( SELECT NULL
793: FROM bom_operation_networks a
794: WHERE a.from_op_seq_id = P_From_Op_Seq_Id
795: AND a.to_op_seq_id <> P_To_Op_Seq_Id
796: AND a.transition_type = 1
797: );

Line 806: FROM bom_operation_networks a

802: IS
803: SELECT 'Not Unique'
804: FROM SYS.DUAL
805: WHERE EXISTS ( SELECT NULL
806: FROM bom_operation_networks a
807: WHERE a.from_op_seq_id = p_from_op_seq_id
808: AND a.to_op_seq_id = p_to_op_seq_id
809: );
810:

Line 1006: FROM bom_operation_networks

1002: AND p_op_network_rec.connection_type IN (1, 2)
1003: THEN
1004: SELECT NVL(SUM(planning_pct), 0)
1005: INTO l_total_planning_pct
1006: FROM bom_operation_networks
1007: WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id
1008: AND to_op_seq_id <> p_op_network_unexp_rec.to_op_seq_id
1009: AND transition_type IN (1, 2);
1010:

Line 1016: FROM bom_operation_networks

1012: IF p_op_network_rec.transaction_type = BOM_Rtg_Globals.G_OPR_UPDATE
1013: THEN
1014: SELECT NVL(planning_pct,0)
1015: INTO l_planning_pct
1016: FROM bom_operation_networks
1017: WHERE from_op_seq_id = p_op_network_unexp_rec.from_op_seq_id
1018: AND to_op_seq_id = p_op_network_unexp_rec.to_op_seq_id
1019: AND transition_type IN (1, 2);
1020: END IF;

Line 1190: FROM bom_operation_networks

1186: THEN
1187:
1188: SELECT NVL(SUM(planning_pct), 0)
1189: INTO l_total_planning_pct
1190: FROM bom_operation_networks
1191: WHERE from_op_seq_id = NVL( p_op_network_unexp_rec.new_from_op_seq_id
1192: , p_op_network_unexp_rec.from_op_seq_id)
1193: AND to_op_seq_id <> NVL( p_op_network_unexp_rec.new_to_op_seq_id
1194: , p_op_network_unexp_rec.to_op_seq_id)