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_SUBSTITUTE_COMPONENTS

Line 360: FROM bom_substitute_components_temp tmp

356: tmp.OriginalSystemReference ,
357: NULL ReturnStatus ,
358: 'UPDATE' TransactionType ,
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,

Line 362: FROM bom_substitute_components sub,

358: 'UPDATE' TransactionType ,
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,

Line 419: FROM bom_substitute_components_temp tmp

415: tmp.OriginalSystemReference ,
416: NULL ReturnStatus ,
417: 'CREATE' TransactionType ,
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,

Line 421: FROM bom_substitute_components sub,

417: 'CREATE' TransactionType ,
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,

Line 806: -- Bom Substitute Components Table

802: -- this closes the handle
803: DBMS_XMLSave.closeContext(insCtx);
804: END IF;
805: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
806: -- Bom Substitute Components Table
807: -- get the context handle
808: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
809: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
810: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

Line 808: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');

804: END IF;
805: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
806: -- Bom Substitute Components Table
807: -- get the context handle
808: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
809: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
810: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
811: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
812: -- this inserts the document

Line 1090: -- Bom Substitute Components Table

1086: END LOOP;
1087: END IF;
1088: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
1089: /*
1090: -- Bom Substitute Components Table
1091: -- get the context handle
1092: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
1093: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1094: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

Line 1092: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');

1088: IF (P_bom_sub_comps_XML IS NOT NULL) THEN
1089: /*
1090: -- Bom Substitute Components Table
1091: -- get the context handle
1092: insCtx := DBMS_XMLSave.newContext('BOM_SUBSTITUTE_COMPONENTS_TEMP');
1093: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1094: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1095: DBMS_XMLSave.setRowTag(insCtx , 'SubstituteComponentsVO');
1096: -- this inserts the document