DBA Data[Home] [Help]

APPS.BOM_RTG_COPYORG_IMP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 116: mtl_system_items_kfv item1,

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,
118: mtl_item_locations_kfv locators
119: WHERE wl.line_id(+) = bor.line_id
120: AND org.organization_id = bor.organization_id

Line 117: mtl_system_items_kfv item2,

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,
118: mtl_item_locations_kfv locators
119: WHERE wl.line_id(+) = bor.line_id
120: AND org.organization_id = bor.organization_id
121: AND item1.organization_id = bor.organization_id

Line 162: mtl_system_items_kfv item

158: NULL Return_Status,
159: NULL Row_Identifier
160: FROM mtl_rtg_item_revisions rev,
161: mtl_parameters org,
162: mtl_system_items_kfv item
163: WHERE org.organization_id = rev.organization_id
164: AND item.organization_id = rev.organization_id
165: AND item.inventory_item_id = rev.inventory_item_id
166: AND item.concatenated_segments = P_assembly_item_name

Line 231: mtl_system_items_kfv item

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
234: AND item.organization_id = rtg.organization_id
235: AND item.inventory_item_id = rtg.assembly_item_id

Line 292: mtl_system_items_kfv item,

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
296: AND org.organization_id = rtg.organization_id

Line 356: mtl_system_items_kfv item,

352: NULL Return_Status,
353: bst.setup_Code Setup_Type,
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,

Line 426: mtl_system_items_kfv item,

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
430: AND bos2.Operation_Sequence_Id = bonv.To_Op_Seq_Id

Line 478: mtl_system_items_kfv item1,

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,
480: mtl_item_locations_kfv locators
481: WHERE wl.line_id(+) = bor.line_id
482: AND org.organization_id = bor.organization_id

Line 479: mtl_system_items_kfv item2,

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,
480: mtl_item_locations_kfv locators
481: WHERE wl.line_id(+) = bor.line_id
482: AND org.organization_id = bor.organization_id
483: AND item1.organization_id = bor.organization_id