APPS.BOM_BOM_ISETUP_IMP dependencies on BOM_INVENTORY_COMPONENTS_TEMP

Line 25: -- Added BasisType to bom_inventory_components_temp table

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
29: ***************************************************************************/

Line 227: FROM bom_inventory_components_temp tmp

223: NULL AutoRequestMaterial ,
224: NULL RowIdentifier ,
225: tmp.SuggestedVendorName ,
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,

Line 307: FROM bom_inventory_components_temp tmp

303: NULL AutoRequestMaterial,
304: NULL RowIdentifier,
305: tmp.SuggestedVendorName,
306: tmp.UnitPrice
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,

Line 798: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');

794: */
795: IF (P_bom_inv_comps_XML IS NOT NULL) THEN
796: -- Bom Inventory Components
797: -- get the context handle
798: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
799: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
800: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
801: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
802: -- this inserts the document

Line 1004: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');

1000: IF (P_bom_inv_comps_XML IS NOT NULL) THEN
1001: /*Moved this code above - TMANDA 26/03/03
1002: -- Bom Inventory Components
1003: -- get the context handle
1004: insCtx := DBMS_XMLSave.newContext('BOM_INVENTORY_COMPONENTS_TEMP');
1005: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1006: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1007: DBMS_XMLSave.setRowTag(insCtx , 'InventoryComponentsVO');
1008: -- this inserts the document