eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_BOM_ISETUP_IMP dependencies on BOM_INVENTORY_COMPONENTS

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 228: FROM bom_inventory_components comp,

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,
231: mtl_system_items_kfv item2,
232: mtl_parameters org

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 309: FROM bom_inventory_components comp,

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,
311: mtl_system_items_kfv item1,
312: mtl_system_items_kfv item2,
313: mtl_parameters org

Line 363: bom_inventory_components comp,

359: NULL RowIdentifier
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,

Line 422: bom_inventory_components comp,

418: NULL RowIdentifier
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,

Line 479: bom_inventory_components comp,

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

Line 532: bom_inventory_components comp,

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

Line 586: bom_inventory_components comp,

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

Line 638: bom_inventory_components comp,

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

Line 794: -- Bom Inventory Components

790: DBMS_XMLSave.closeContext(insCtx);
791: END IF;
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');

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 999: -- Bom Inventory Components

995: */
996: -- END IF;
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');

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