[Home] [Help]
24: -- all Boms from source organization and
25: -- pass all the records to Bom Interface.
26: -- Bom Interface will do the copying.
27: -- 03-JUL-06 Mohan Yerramsetty Added ImplementationDate to bom_bill_of_materials_temp table
28: -- Added BasisType to bom_inventory_components_temp table
29: -- Bug: 5174575
30: -- 11-NOV-06 Mohan Yerramsetty Modified the code to delete the successfully processed
31: -- records after the call to BOM_BO_PUB.Process_Bom to reduce
32: -- the memory consumed by the process. Bug: 5654718
194: NULL RowIdentifier,
195: comp.suggested_vendor_name SuggestedVendorName,
196: comp.unit_price UnitPrice,
197: comp.basis_type BasisType --Bug: 5174575: New attribute added for R12
198: FROM bom_inventory_components comp,
199: mtl_system_items_kfv item1,
200: mtl_parameters org,
201: bom_bill_of_materials bom,
202: mtl_system_items_kfv item2
246: FROM bom_substitute_components sub,
247: mtl_system_items_kfv item1,
248: mtl_parameters org,
249: bom_bill_of_materials bom,
250: bom_inventory_components comp,
251: mtl_system_items_kfv item2,
252: mtl_system_items_kfv item3
253: WHERE comp.component_sequence_id = sub.component_sequence_id
254: AND bom.bill_sequence_id = comp.bill_sequence_id
296: NULL RowIdentifier
297: FROM bom_reference_designators ref,
298: mtl_system_items_kfv item1,
299: mtl_parameters org,
300: bom_inventory_components comp,
301: mtl_system_items_kfv item2,
302: bom_bill_of_materials bom
303: WHERE comp.component_sequence_id = ref.component_sequence_id
304: AND bom.bill_sequence_id = comp.bill_sequence_id
343: NULL RowIdentifier
344: FROM bom_component_operations comp_oper,
345: mtl_system_items_kfv item1,
346: mtl_parameters org,
347: bom_inventory_components comp,
348: mtl_system_items_kfv item2,
349: bom_bill_of_materials bom
350: WHERE comp.component_sequence_id = comp_oper.component_sequence_id
351: AND bom.bill_sequence_id = comp.bill_sequence_id