[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
289: bom_resources br,
290: cst_activities ca,
291: bom_setup_types bst,
292: bom_operation_sequences op_seq,
293: bom_operational_routings rtg,
294: mtl_system_items_kfv item,
295: mtl_parameters org
296: WHERE op_seq.operation_sequence_id = bor.operation_sequence_id
297: AND rtg.routing_sequence_id = op_seq.routing_sequence_id
357: NULL Row_Identifier
358: FROM bom_sub_operation_resources bsor,
359: mtl_system_items_kfv item,
360: mtl_parameters org,
361: bom_operational_routings rtg,
362: bom_operation_sequences op_seq,
363: bom_resources br,
364: cst_activities ca,
365: bom_setup_types bst
424: NULL Row_Identifier
425: FROM bom_operation_networks_v bonv,
426: bom_operation_sequences bos1,
427: bom_operation_sequences bos2,
428: bom_operational_routings rtg,
429: mtl_system_items_kfv item,
430: mtl_parameters org
431: WHERE rtg.routing_sequence_id = bonv.routing_sequence_id
432: AND bos1.Operation_Sequence_Id = bonv.From_Op_Seq_Id
474:
475: --myerrams, To get the number of routings in Model org.
476: SELECT COUNT(*)
477: INTO l_hdr_cnt
478: FROM bom_operational_routings bor,
479: wip_lines wl,
480: mtl_parameters org,
481: mtl_system_items_kfv item1,
482: mtl_system_items_kfv item2,