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

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

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

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

Line 364: bom_inventory_components comp,

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

Line 423: bom_inventory_components comp,

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

Line 480: bom_inventory_components comp,

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

Line 533: bom_inventory_components comp,

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

Line 587: bom_inventory_components comp,

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

Line 639: bom_inventory_components comp,

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

Line 796: -- Bom Inventory Components

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

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

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

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