APPS.BOM_BOM_ISETUP_IMP dependencies on BOM_BILL_OF_MATERIALS

Line 24: -- 23-DEC-05 MYERRAMS Added ImplementationDate to bom_bill_of_materials_temp table

20: -- 18-NOV-02 M V M P Tilak Initial Creation
21: -- 26-MAR-03 M V M P Tilak Modified for XSU utility work-around
22: -- 10-FEB-04 Anupam Jain Bug# 3349138, avoid redundant migration of
23: -- Item Revisions data.
24: -- 23-DEC-05 MYERRAMS Added ImplementationDate to bom_bill_of_materials_temp table
25: -- Added BasisType to bom_inventory_components_temp table
26: -- Bug: 4873339
27: -- 05-MAY-05 MYERRAMS Modified the ImplementationDate conversion.
28: -- Bug: 5141752

Line 111: FROM bom_bill_of_materials_temp tmp,

107: tmp.ImplementationDate , --myerrams, bug: 4873339. New Column added for R12.
108: NULL DeleteGroupName ,
109: NULL DGDescription ,
110: NULL RowIdentifier
111: FROM bom_bill_of_materials_temp tmp,
112: mtl_system_items_kfv item,
113: mtl_parameters org
114: WHERE org.organization_code = tmp.OrganizationCode
115: AND item.concatenated_segments = tmp.AssemblyItemName

Line 118: FROM bom_bill_of_materials bom

114: WHERE org.organization_code = tmp.OrganizationCode
115: AND item.concatenated_segments = tmp.AssemblyItemName
116: AND item.organization_id = org.organization_id
117: AND EXISTS (SELECT 1
118: FROM bom_bill_of_materials bom
119: WHERE bom.assembly_item_id = item.inventory_item_id
120: AND bom.organization_id = org.organization_id
121: AND NVL(bom.alternate_bom_designator,'##$$##') = NVL(tmp.AlternateBomCode,'##$$##')
122: AND bom.common_assembly_item_id is null)

Line 154: FROM bom_bill_of_materials_temp tmp,

150: tmp.ImplementationDate , --myerrams, bug: 4873339. New Column added for R12.
151: NULL DeleteGroupName ,
152: NULL DGDescription ,
153: NULL RowIdentifier
154: FROM bom_bill_of_materials_temp tmp,
155: mtl_system_items_kfv item,
156: mtl_parameters org
157: WHERE org.organization_code = tmp.OrganizationCode
158: AND item.concatenated_segments = tmp.AssemblyItemName

Line 161: FROM bom_bill_of_materials bom

157: WHERE org.organization_code = tmp.OrganizationCode
158: AND item.concatenated_segments = tmp.AssemblyItemName
159: AND item.organization_id = org.organization_id
160: AND NOT EXISTS (SELECT 1
161: FROM bom_bill_of_materials bom
162: WHERE bom.assembly_item_id = item.inventory_item_id
163: AND bom.organization_id = org.organization_id
164: AND NVL(bom.alternate_bom_designator,'##$$##') = NVL(tmp.AlternateBomCode,'##$$##')))
165: v order by v.CommonAssemblyItemName desc;

Line 230: bom_bill_of_materials bom,

226: tmp.UnitPrice
227: FROM bom_inventory_components_temp tmp
228: WHERE EXISTS (SELECT 1
229: FROM bom_inventory_components comp,
230: bom_bill_of_materials bom,
231: mtl_system_items_kfv item1,
232: mtl_system_items_kfv item2,
233: mtl_parameters org
234: WHERE bom.bill_sequence_id = comp.bill_sequence_id

Line 311: bom_bill_of_materials bom,

307: FROM bom_inventory_components_temp tmp
308: WHERE NOT EXISTS
309: (SELECT 1
310: FROM bom_inventory_components comp,
311: bom_bill_of_materials bom,
312: mtl_system_items_kfv item1,
313: mtl_system_items_kfv item2,
314: mtl_parameters org
315: WHERE bom.bill_sequence_id = comp.bill_sequence_id

Line 365: bom_bill_of_materials bom,

361: FROM bom_substitute_components_temp tmp
362: WHERE EXISTS (SELECT 1
363: FROM bom_substitute_components sub,
364: bom_inventory_components comp,
365: bom_bill_of_materials bom,
366: mtl_parameters org,
367: mtl_system_items_kfv item1,
368: mtl_system_items_kfv item2,
369: mtl_system_items_kfv item3

Line 424: bom_bill_of_materials bom,

420: FROM bom_substitute_components_temp tmp
421: WHERE NOT EXISTS (SELECT 1
422: FROM bom_substitute_components sub,
423: bom_inventory_components comp,
424: bom_bill_of_materials bom,
425: mtl_parameters org,
426: mtl_system_items_kfv item1,
427: mtl_system_items_kfv item2,
428: mtl_system_items_kfv item3

Line 481: bom_bill_of_materials bom,

477: FROM bom_reference_designators_temp tmp
478: WHERE NOT EXISTS (SELECT 1
479: FROM bom_reference_designators ref,
480: bom_inventory_components comp,
481: bom_bill_of_materials bom,
482: mtl_parameters org,
483: mtl_system_items_kfv item1,
484: mtl_system_items_kfv item2
485: WHERE comp.component_sequence_id = ref.component_sequence_id

Line 534: bom_bill_of_materials bom,

530: FROM bom_reference_designators_temp tmp
531: WHERE EXISTS (SELECT 1
532: FROM bom_reference_designators ref,
533: bom_inventory_components comp,
534: bom_bill_of_materials bom,
535: mtl_parameters org,
536: mtl_system_items_kfv item1,
537: mtl_system_items_kfv item2
538: WHERE comp.component_sequence_id = ref.component_sequence_id

Line 588: bom_bill_of_materials bom,

584: FROM bom_component_operations_temp tmp
585: WHERE NOT EXISTS (SELECT 1
586: FROM bom_component_operations comp_oper,
587: bom_inventory_components comp,
588: bom_bill_of_materials bom,
589: mtl_parameters org,
590: mtl_system_items_kfv item1,
591: mtl_system_items_kfv item2
592: WHERE comp.component_sequence_id = comp_oper.component_sequence_id

Line 640: bom_bill_of_materials bom,

636: FROM bom_component_operations_temp tmp
637: WHERE EXISTS (SELECT 1
638: FROM bom_component_operations comp_oper,
639: bom_inventory_components comp,
640: bom_bill_of_materials bom,
641: mtl_parameters org,
642: mtl_system_items_kfv item1,
643: mtl_system_items_kfv item2
644: WHERE comp.component_sequence_id = comp_oper.component_sequence_id

Line 773: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');

769: -- Bom Header Record
770:
771: IF (P_bom_header_XML IS NOT NULL) THEN
772: -- get the context handle
773: insCtx := DBMS_XMLSave.newContext('BOM_BILL_OF_MATERIALS_TEMP');
774: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
775: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
776: DBMS_XMLSave.setRowTag(insCtx , 'BillOfMaterialsVO');
777: -- this inserts the document