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:

Line 229: bom_bill_of_materials bom,

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

Line 310: bom_bill_of_materials bom,

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

Line 364: bom_bill_of_materials bom,

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

Line 423: bom_bill_of_materials bom,

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

Line 480: bom_bill_of_materials bom,

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

Line 533: bom_bill_of_materials bom,

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

Line 587: bom_bill_of_materials bom,

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

Line 639: bom_bill_of_materials bom,

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

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

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