[Home] [Help]
34: IS
35:
36: CURSOR c_Nwk_Exists IS
37: SELECT 'Valid Nwk Exists'
38: FROM BOM_OPERATION_NETWORKS bon
39: WHERE exists ( SELECT operation_sequence_id
40: FROM bom_operation_sequences bos
41: WHERE bos.operation_sequence_id = bon.from_op_seq_id
42: AND bos.routing_sequence_id = p_routing_sequence_id
86: , bon.to_op_seq_id to_op_seq_id
87: , bos2.operation_seq_num to_op_seq_num
88: , bon.transition_type transition_type
89: , bon.planning_pct planning_pct
90: FROM BOM_OPERATION_NETWORKS bon
91: , BOM_OPERATION_SEQUENCES bos1
92: , BOM_OPERATION_SEQUENCES bos2
93: WHERE nvl(bon.disable_date,SYSDATE+2) > SYSDATE
94: AND bon.transition_type <> 3
171: , bon.to_op_seq_id to_op_seq_id
172: , bos2.operation_seq_num to_op_seq_num
173: , bon.transition_type transition_type
174: , bon.planning_pct planning_pct
175: FROM BOM_OPERATION_NETWORKS bon
176: , BOM_OPERATION_SEQUENCES bos1
177: , BOM_OPERATION_SEQUENCES bos2
178: WHERE NOT EXISTS ( SELECT NULL
179: FROM BOM_OPERATION_NETWORKS bon2
175: FROM BOM_OPERATION_NETWORKS bon
176: , BOM_OPERATION_SEQUENCES bos1
177: , BOM_OPERATION_SEQUENCES bos2
178: WHERE NOT EXISTS ( SELECT NULL
179: FROM BOM_OPERATION_NETWORKS bon2
180: WHERE bon2.to_op_seq_id = bon.from_op_seq_id
181: )
182: AND nvl(bon.disable_date,SYSDATE+2) > SYSDATE
183: AND bon.transition_type <> 3
267: SELECT from_op_seq_id
268: , to_op_seq_id
269: , transition_type
270: , planning_pct
271: FROM BOM_OPERATION_NETWORKS
272: START WITH from_op_seq_id = p_from_op_seq_id
273: AND transition_type <> 3
274: CONNECT BY PRIOR to_op_seq_id = from_op_seq_id
275: AND transition_type <> 3;
1086: SELECT 'x' dummy
1087: FROM DUAL
1088: WHERE EXISTS
1089: ( SELECT NULL
1090: FROM bom_operation_networks a
1091: WHERE a.from_op_seq_id = P_From_Op_Seq_Id
1092: AND a.to_op_seq_id <> P_To_Op_Seq_Id
1093: AND a.transition_type = 1
1094: );