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 294: mtl_system_items_kfv item,

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

Line 359: mtl_system_items_kfv item,

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

Line 429: mtl_system_items_kfv item,

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

Line 481: mtl_system_items_kfv item1,

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

Line 482: mtl_system_items_kfv item2,

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