[Home] [Help]
109: NULL Delete_Group_Name,
110: NULL DG_Description,
111: NULL ser_start_op_seq,
112: NULL row_identifier
113: FROM bom_operational_routings bor,
114: wip_lines wl,
115: mtl_parameters org,
116: mtl_system_items_kfv item1,
117: mtl_system_items_kfv item2,
225: NULL DG_Description,
226: NULL Long_Description,
227: NULL Row_Identifier
228: FROM bom_operation_sequences_v op_seq,
229: bom_operational_routings rtg,
230: mtl_parameters org,
231: mtl_system_items_kfv item
232: WHERE rtg.routing_sequence_id = op_seq.routing_sequence_id
233: AND org.organization_id = rtg.organization_id
287: bom_resources br,
288: cst_activities ca,
289: bom_setup_types bst,
290: bom_operation_sequences op_seq,
291: bom_operational_routings rtg,
292: mtl_system_items_kfv item,
293: mtl_parameters org
294: WHERE op_seq.operation_sequence_id = bor.operation_sequence_id
295: AND rtg.routing_sequence_id = op_seq.routing_sequence_id
354: NULL Row_Identifier
355: FROM bom_sub_operation_resources bsor,
356: mtl_system_items_kfv item,
357: mtl_parameters org,
358: bom_operational_routings rtg,
359: bom_operation_sequences op_seq,
360: bom_resources br,
361: cst_activities ca,
362: bom_setup_types bst
421: NULL Row_Identifier
422: FROM bom_operation_networks_v bonv,
423: bom_operation_sequences bos1,
424: bom_operation_sequences bos2,
425: bom_operational_routings rtg,
426: mtl_system_items_kfv item,
427: mtl_parameters org
428: WHERE rtg.routing_sequence_id = bonv.routing_sequence_id
429: AND bos1.Operation_Sequence_Id = bonv.From_Op_Seq_Id
471:
472: --myerrams, To get the number of routings in Model org.
473: SELECT COUNT(*)
474: INTO l_hdr_cnt
475: FROM bom_operational_routings bor,
476: wip_lines wl,
477: mtl_parameters org,
478: mtl_system_items_kfv item1,
479: mtl_system_items_kfv item2,