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 157: x_reg_item_rec.DUALUM_IND := 0;

153:
154: x_reg_item_rec.ITEM_NO := l_reg_rec.item_code;
155: x_reg_item_rec.ITEM_DESC1 := l_description;
156: x_reg_item_rec.ITEM_UM := l_uom;
157: x_reg_item_rec.DUALUM_IND := 0;
158: x_reg_item_rec.DEVIATION_LO := 0;
159: x_reg_item_rec.DEVIATION_HI := 0;
160: x_reg_item_rec.LOT_CTL := 0;
161: x_reg_item_rec.LOT_INDIVISIBLE := 0;

Line 355: FROM dual

351: EXCEPTION
352: WHEN NO_DATA_FOUND THEN
353: SELECT mtl_system_items_s.nextval
354: INTO l_inventory_item_id
355: FROM dual
356: WHERE rownum = 1;
357: END;
358:
359: -- -- dbms_output.put_line ('Migrate Action = '||l_action);

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

404: INTO l_prim_uom_code, l_prim_unit_of_meassure
405: FROM sy_uoms_mst
406: WHERE um_code = l_opm_item.item_um;
407:
408: IF (l_opm_item.dualum_ind > 0) THEN
409: l_field_name := 'Secondary UOM';
410: l_field_value := l_opm_item.item_um2;
411: SELECT uom_code,unit_of_measure
412: INTO l_sec_uom_code, l_sec_unit_of_meassure

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

611: IF (l_opm_item.status_ctl IN (1,2)) THEN
612: l_item_rec.LOT_STATUS_ENABLED := 'Y';
613: END IF;
614: l_item_rec.DEFAULT_LOT_STATUS_ID := l_status_id;
615: l_item_rec.DUAL_UOM_CONTROL := l_opm_item.dualum_ind + 1;
616: l_item_rec.SECONDARY_UOM_CODE := l_sec_uom_code;
617: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
618: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
619: l_item_rec.SECONDARY_DEFAULT_IND := NULL;

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

613: END IF;
614: l_item_rec.DEFAULT_LOT_STATUS_ID := l_status_id;
615: l_item_rec.DUAL_UOM_CONTROL := l_opm_item.dualum_ind + 1;
616: l_item_rec.SECONDARY_UOM_CODE := l_sec_uom_code;
617: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
618: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
619: l_item_rec.SECONDARY_DEFAULT_IND := NULL;
620: l_item_rec.TRACKING_QUANTITY_IND := 'P';
621: IF (l_opm_item.dualum_ind > 0) THEN

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

614: l_item_rec.DEFAULT_LOT_STATUS_ID := l_status_id;
615: l_item_rec.DUAL_UOM_CONTROL := l_opm_item.dualum_ind + 1;
616: l_item_rec.SECONDARY_UOM_CODE := l_sec_uom_code;
617: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
618: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
619: l_item_rec.SECONDARY_DEFAULT_IND := NULL;
620: l_item_rec.TRACKING_QUANTITY_IND := 'P';
621: IF (l_opm_item.dualum_ind > 0) THEN
622: l_item_rec.TRACKING_QUANTITY_IND := 'PS';

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

617: l_item_rec.DUAL_UOM_DEVIATION_HIGH := nvl(l_opm_item.deviation_lo*100,0);
618: l_item_rec.DUAL_UOM_DEVIATION_LOW := nvl(l_opm_item.deviation_hi*100,0);
619: l_item_rec.SECONDARY_DEFAULT_IND := NULL;
620: l_item_rec.TRACKING_QUANTITY_IND := 'P';
621: IF (l_opm_item.dualum_ind > 0) THEN
622: l_item_rec.TRACKING_QUANTITY_IND := 'PS';
623: IF (l_opm_item.dualum_ind = 1) THEN
624: l_item_rec.SECONDARY_DEFAULT_IND := 'F';
625: ELSIF (l_opm_item.dualum_ind = 2) THEN

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

619: l_item_rec.SECONDARY_DEFAULT_IND := NULL;
620: l_item_rec.TRACKING_QUANTITY_IND := 'P';
621: IF (l_opm_item.dualum_ind > 0) THEN
622: l_item_rec.TRACKING_QUANTITY_IND := 'PS';
623: IF (l_opm_item.dualum_ind = 1) THEN
624: l_item_rec.SECONDARY_DEFAULT_IND := 'F';
625: ELSIF (l_opm_item.dualum_ind = 2) THEN
626: l_item_rec.SECONDARY_DEFAULT_IND := 'D';
627: ELSE

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

621: IF (l_opm_item.dualum_ind > 0) THEN
622: l_item_rec.TRACKING_QUANTITY_IND := 'PS';
623: IF (l_opm_item.dualum_ind = 1) THEN
624: l_item_rec.SECONDARY_DEFAULT_IND := 'F';
625: ELSIF (l_opm_item.dualum_ind = 2) THEN
626: l_item_rec.SECONDARY_DEFAULT_IND := 'D';
627: ELSE
628: l_item_rec.SECONDARY_DEFAULT_IND := 'N';
629: END IF;

Line 1025: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',

1021: attribute_name IN ( 'MTL_SYSTEM_ITEMS.TRACKING_QUANTITY_IND',
1022: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1023: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1024: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1025: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1026: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1027: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1028: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1029: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',

Line 1026: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',

1022: 'MTL_SYSTEM_ITEMS.ONT_PRICING_QTY_SOURCE',
1023: 'MTL_SYSTEM_ITEMS.SECONDARY_DEFAULT_IND',
1024: 'MTL_SYSTEM_ITEMS.SECONDARY_UOM_CODE',
1025: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_HIGH',
1026: 'MTL_SYSTEM_ITEMS.DUAL_UOM_DEVIATION_LOW',
1027: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',
1028: 'MTL_SYSTEM_ITEMS.AUTO_LOT_ALPHA_PREFIX',
1029: 'MTL_SYSTEM_ITEMS.ENG_ITEM_FLAG',
1030: 'MTL_SYSTEM_ITEMS.ITEM_TYPE',

Line 1852: FROM dual

1848: 'UPC_CODE', i.UPC_CODE,
1849: 'QCITEM_ID', i.QCITEM_ID,
1850: 'QCHOLD_RES_CODE', i.QCHOLD_RES_CODE)
1851: INTO l_obsolete_column_value
1852: FROM dual
1853: WHERE rownum = 1;
1854:
1855: UPDATE mtl_system_items_b
1856: SET