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 226: FROM bom_inventory_components_temp tmp

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

Line 306: FROM bom_inventory_components_temp tmp

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

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

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

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

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