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 476: FROM bom_reference_designators_temp tmp

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

Line 478: FROM bom_reference_designators ref,

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

Line 529: FROM bom_reference_designators_temp tmp

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

Line 531: FROM bom_reference_designators ref,

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

Line 818: -- Bom Reference Designators Table

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

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

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

Line 1150: -- Bom Reference Designators Table

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

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

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