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_LOT_APIS dependencies on MTL_UNITS_OF_MEASURE

Line 1010: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;

1006: l_org_id NUMBER ;
1007: l_create_lot_uom_conv NUMBER;
1008: l_from_uom_code VARCHAR2(10);
1009: l_to_uom_code VARCHAR2(10);
1010: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
1011: l_from_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;
1012: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
1013: l_to_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;
1014: l_display_conversions VARCHAR2(10) ;

Line 1011: l_from_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;

1007: l_create_lot_uom_conv NUMBER;
1008: l_from_uom_code VARCHAR2(10);
1009: l_to_uom_code VARCHAR2(10);
1010: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
1011: l_from_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;
1012: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
1013: l_to_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;
1014: l_display_conversions VARCHAR2(10) ;
1015:

Line 1012: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;

1008: l_from_uom_code VARCHAR2(10);
1009: l_to_uom_code VARCHAR2(10);
1010: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
1011: l_from_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;
1012: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
1013: l_to_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;
1014: l_display_conversions VARCHAR2(10) ;
1015:
1016: Begin

Line 1013: l_to_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;

1009: l_to_uom_code VARCHAR2(10);
1010: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
1011: l_from_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;
1012: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.unit_of_measure_tl%TYPE;
1013: l_to_uom_class MTL_UNITS_OF_MEASURE.uom_class%TYPE;
1014: l_display_conversions VARCHAR2(10) ;
1015:
1016: Begin
1017:

Line 1042: FROM MTL_UNITS_OF_MEASURE

1038:
1039: BEGIN
1040: SELECT unit_of_measure_tl, uom_class
1041: INTO l_from_unit_of_measure, l_from_uom_class
1042: FROM MTL_UNITS_OF_MEASURE
1043: WHERE UOM_CODE = l_from_uom_Code;
1044: EXCEPTION
1045: WHEN OTHERS THEN
1046: l_from_unit_of_measure := NULL;

Line 1053: FROM MTL_UNITS_OF_MEASURE

1049:
1050: BEGIN
1051: SELECT unit_of_measure_tl, uom_class
1052: INTO l_to_unit_of_measure, l_to_uom_class
1053: FROM MTL_UNITS_OF_MEASURE
1054: WHERE UOM_CODE = l_to_uom_Code;
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: l_to_unit_of_measure := NULL;

Line 1201: l_from_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1197: l_origin_txn_id NUMBER;
1198: l_source NUMBER;
1199: l_create_lot_uom_conv NUMBER;
1200: l_org_id NUMBER;
1201: l_from_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1202: l_to_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1203: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1204: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1205: l_from_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

Line 1202: l_to_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1198: l_source NUMBER;
1199: l_create_lot_uom_conv NUMBER;
1200: l_org_id NUMBER;
1201: l_from_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1202: l_to_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1203: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1204: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1205: l_from_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1206: l_to_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

Line 1203: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;

1199: l_create_lot_uom_conv NUMBER;
1200: l_org_id NUMBER;
1201: l_from_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1202: l_to_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1203: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1204: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1205: l_from_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1206: l_to_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1207: l_conversion_rate MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_RATE%TYPE;

Line 1204: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;

1200: l_org_id NUMBER;
1201: l_from_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1202: l_to_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1203: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1204: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1205: l_from_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1206: l_to_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1207: l_conversion_rate MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_RATE%TYPE;
1208: x_conversion_rate MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_RATE%TYPE;

Line 1205: l_from_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

1201: l_from_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1202: l_to_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1203: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1204: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1205: l_from_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1206: l_to_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1207: l_conversion_rate MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_RATE%TYPE;
1208: x_conversion_rate MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_RATE%TYPE;
1209: l_go BOOLEAN;

Line 1206: l_to_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

1202: l_to_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1203: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1204: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;
1205: l_from_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1206: l_to_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;
1207: l_conversion_rate MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_RATE%TYPE;
1208: x_conversion_rate MTL_LOT_UOM_CLASS_CONVERSIONS.CONVERSION_RATE%TYPE;
1209: l_go BOOLEAN;
1210: l_response NUMBER;

Line 1219: l_primary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

1215: l_row_id ROWID;
1216: l_exists VARCHAR2(10);
1217: L_LOT_UOM_CONVERSION VARCHAR2(10);
1218: l_sec_qty Number := 0;
1219: l_primary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;
1220: l_primary_quantity NUMBER ;
1221: l_ITEM_DUAL_UOM_CONTROL mtl_system_items.tracking_quantity_ind%TYPE ;
1222: l_copy_pnt_lot_att_flag mtl_system_items.copy_lot_attribute_flag%TYPE ;
1223: l_secondary_default_ind mtl_system_items.secondary_default_ind%TYPE ;

Line 1600: FROM MTL_UNITS_OF_MEASURE

1596: l_to_uom_code := l_secondary_uom_code ;
1597: BEGIN
1598: SELECT unit_of_measure_tl, uom_class
1599: INTO l_from_unit_of_measure, l_from_uom_class
1600: FROM MTL_UNITS_OF_MEASURE
1601: WHERE UOM_CODE = l_from_uom_Code;
1602: -- Spr_Debug('100: ');
1603:
1604: EXCEPTION

Line 1615: FROM MTL_UNITS_OF_MEASURE

1611: -- Spr_Debug('120: ');
1612: BEGIN
1613: SELECT unit_of_measure_tl, uom_class
1614: INTO l_to_unit_of_measure, l_to_uom_class
1615: FROM MTL_UNITS_OF_MEASURE
1616: WHERE UOM_CODE = l_to_uom_Code;
1617: -- Spr_Debug('130: ');
1618:
1619: EXCEPTION