APPS.BOM_BOM_COPYORG_IMP dependencies on BOM_BILL_OF_MATERIALS

Line 27: -- 03-JUL-06 Mohan Yerramsetty Added ImplementationDate to bom_bill_of_materials_temp table

23: -- Importing from XML Logic. This will fetch
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

Line 122: FROM bom_bill_of_materials bom,

118: NULL DeleteGroupName,
119: NULL DGDescription,
120: NULL RowIdentifier,
121: to_char(bom.implementation_date,'YYYY-MM-DD HH24:MI:SS') ImplementationDate --Bug: 5174575: New attribute added for R12
122: FROM bom_bill_of_materials bom,
123: mtl_system_items_kfv item1,
124: mtl_parameters org1,
125: mtl_parameters org2,
126: mtl_system_items_kfv item2

Line 201: bom_bill_of_materials bom,

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
203: WHERE bom.bill_sequence_id = comp.bill_sequence_id
204: AND org.organization_id = bom.organization_id
205: AND item1.organization_id = bom.organization_id

Line 249: bom_bill_of_materials bom,

245: NULL RowIdentifier
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

Line 302: bom_bill_of_materials bom

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
305: AND org.organization_id = bom.organization_id
306: AND item1.organization_id = bom.organization_id

Line 349: bom_bill_of_materials bom

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
352: AND org.organization_id = bom.organization_id
353: AND item1.organization_id = bom.organization_id