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_REFERENCE_DESIGNATORS

Line 477: FROM bom_reference_designators_temp tmp

473: tmp.NewReferenceDesignator ,
474: NULL ReturnStatus ,
475: 'CREATE' TransactionType ,
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,

Line 479: FROM bom_reference_designators ref,

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

Line 530: FROM bom_reference_designators_temp tmp

526: tmp.NewReferenceDesignator ,
527: NULL ReturnStatus ,
528: 'UPDATE' TransactionType ,
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,

Line 532: FROM bom_reference_designators ref,

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

Line 820: -- Bom Reference Designators Table

816: -- this closes the handle
817: DBMS_XMLSave.closeContext(insCtx);
818: END IF;
819: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN
820: -- Bom Reference Designators Table
821: -- get the context handle
822: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
823: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
824: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

Line 822: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');

818: END IF;
819: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN
820: -- Bom Reference Designators Table
821: -- get the context handle
822: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
823: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
824: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
825: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
826: -- this inserts the document

Line 1153: -- Bom Reference Designators Table

1149: END LOOP;
1150: END IF;
1151: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN
1152: /*
1153: -- Bom Reference Designators Table
1154: -- get the context handle
1155: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
1156: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1157: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');

Line 1155: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');

1151: IF (P_bom_ref_desgs_XML IS NOT NULL) THEN
1152: /*
1153: -- Bom Reference Designators Table
1154: -- get the context handle
1155: insCtx := DBMS_XMLSave.newContext('BOM_REFERENCE_DESIGNATORS_TEMP');
1156: DBMS_XMLSave.setIgnoreCase(insCtx, 1);
1157: DBMS_XMLSave.setDateFormat(insCtx, 'yyyy-MM-dd HH:mm:ss');
1158: DBMS_XMLSave.setRowTag(insCtx , 'ReferenceDesignatorsVO');
1159: -- this inserts the document