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.INV_OPM_ITEM_MIGRATION dependencies on DUAL

Line 172: x_reg_item_rec.DUALUM_IND := 0;

168:
169: x_reg_item_rec.ITEM_NO := l_reg_rec.item_code;
170: x_reg_item_rec.ITEM_DESC1 := l_description;
171: x_reg_item_rec.ITEM_UM := l_uom;
172: x_reg_item_rec.DUALUM_IND := 0;
173: x_reg_item_rec.DEVIATION_LO := 0;
174: x_reg_item_rec.DEVIATION_HI := 0;
175: x_reg_item_rec.LOT_CTL := 0;
176: x_reg_item_rec.LOT_INDIVISIBLE := 0;

Line 425: FROM dual

421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: SELECT mtl_system_items_s.nextval
424: INTO l_inventory_item_id
425: FROM dual
426: WHERE rownum = 1;
427: END;
428:
429: -- -- dbms_output.put_line ('Migrate Action = '||l_action);

Line 478: IF (l_opm_item.dualum_ind > 0) THEN

474: INTO l_prim_uom_code, l_prim_unit_of_meassure
475: FROM sy_uoms_mst
476: WHERE um_code = l_opm_item.item_um;
477:
478: IF (l_opm_item.dualum_ind > 0) THEN
479: l_field_name := 'Secondary UOM';
480: l_field_value := l_opm_item.item_um2;
481: SELECT uom_code,unit_of_measure
482: INTO l_sec_uom_code, l_sec_unit_of_meassure

Line 699: l_item_rec.DUAL_UOM_CONTROL := l_opm_item.dualum_ind + 1;

695: IF (l_opm_item.status_ctl IN (1,2)) THEN
696: l_item_rec.LOT_STATUS_ENABLED := 'Y';
697: END IF;
698: l_item_rec.DEFAULT_LOT_STATUS_ID := l_status_id;
699: l_item_rec.DUAL_UOM_CONTROL := l_opm_item.dualum_ind + 1;
700: l_item_rec.SECONDARY_UOM_CODE := l_sec_uom_code;
701: -- l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
702: -- l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
703: -- Bug 11887554 Corrected the deviation assignment (old code above)

Line 701: -- l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);

697: END IF;
698: l_item_rec.DEFAULT_LOT_STATUS_ID := l_status_id;
699: l_item_rec.DUAL_UOM_CONTROL := l_opm_item.dualum_ind + 1;
700: l_item_rec.SECONDARY_UOM_CODE := l_sec_uom_code;
701: -- l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
702: -- l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
703: -- Bug 11887554 Corrected the deviation assignment (old code above)
704: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_hi*100,0);
705: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_lo*100,0);

Line 702: -- l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);

698: l_item_rec.DEFAULT_LOT_STATUS_ID := l_status_id;
699: l_item_rec.DUAL_UOM_CONTROL := l_opm_item.dualum_ind + 1;
700: l_item_rec.SECONDARY_UOM_CODE := l_sec_uom_code;
701: -- l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
702: -- l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
703: -- Bug 11887554 Corrected the deviation assignment (old code above)
704: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_hi*100,0);
705: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_lo*100,0);
706: l_item_rec.SECONDARY_DEFAULT_IND := NULL;

Line 704: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_hi*100,0);

700: l_item_rec.SECONDARY_UOM_CODE := l_sec_uom_code;
701: -- l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
702: -- l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
703: -- Bug 11887554 Corrected the deviation assignment (old code above)
704: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_hi*100,0);
705: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_lo*100,0);
706: l_item_rec.SECONDARY_DEFAULT_IND := NULL;
707: l_item_rec.TRACKING_QUANTITY_IND := 'P';
708: IF (l_opm_item.dualum_ind > 0) THEN

Line 705: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_lo*100,0);

701: -- l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
702: -- l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
703: -- Bug 11887554 Corrected the deviation assignment (old code above)
704: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_hi*100,0);
705: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_lo*100,0);
706: l_item_rec.SECONDARY_DEFAULT_IND := NULL;
707: l_item_rec.TRACKING_QUANTITY_IND := 'P';
708: IF (l_opm_item.dualum_ind > 0) THEN
709: l_item_rec.TRACKING_QUANTITY_IND := 'PS';

Line 708: IF (l_opm_item.dualum_ind > 0) THEN

704: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_hi*100,0);
705: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_lo*100,0);
706: l_item_rec.SECONDARY_DEFAULT_IND := NULL;
707: l_item_rec.TRACKING_QUANTITY_IND := 'P';
708: IF (l_opm_item.dualum_ind > 0) THEN
709: l_item_rec.TRACKING_QUANTITY_IND := 'PS';
710: IF (l_opm_item.dualum_ind = 1) THEN
711: l_item_rec.SECONDARY_DEFAULT_IND := 'F';
712: ELSIF (l_opm_item.dualum_ind = 2) THEN

Line 710: IF (l_opm_item.dualum_ind = 1) THEN

706: l_item_rec.SECONDARY_DEFAULT_IND := NULL;
707: l_item_rec.TRACKING_QUANTITY_IND := 'P';
708: IF (l_opm_item.dualum_ind > 0) THEN
709: l_item_rec.TRACKING_QUANTITY_IND := 'PS';
710: IF (l_opm_item.dualum_ind = 1) THEN
711: l_item_rec.SECONDARY_DEFAULT_IND := 'F';
712: ELSIF (l_opm_item.dualum_ind = 2) THEN
713: l_item_rec.SECONDARY_DEFAULT_IND := 'D';
714: ELSE

Line 712: ELSIF (l_opm_item.dualum_ind = 2) THEN

708: IF (l_opm_item.dualum_ind > 0) THEN
709: l_item_rec.TRACKING_QUANTITY_IND := 'PS';
710: IF (l_opm_item.dualum_ind = 1) THEN
711: l_item_rec.SECONDARY_DEFAULT_IND := 'F';
712: ELSIF (l_opm_item.dualum_ind = 2) THEN
713: l_item_rec.SECONDARY_DEFAULT_IND := 'D';
714: ELSE
715: l_item_rec.SECONDARY_DEFAULT_IND := 'N';
716: END IF;

Line 1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',

1108: attribute_name IN ( 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND',
1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',

Line 1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',

1109: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1110: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1111: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1112: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1113: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1114: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1115: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1116: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1117: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',

Line 1950: FROM dual

1946: 'UPC_CODE', i.UPC_CODE,
1947: 'QCITEM_ID', i.QCITEM_ID,
1948: 'QCHOLD_RES_CODE', i.QCHOLD_RES_CODE)
1949: INTO l_obsolete_column_value
1950: FROM dual
1951: WHERE rownum = 1;
1952:
1953: UPDATE mtl_system_items_b
1954: SET