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 1199: l_from_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

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

Line 1200: l_to_uom_code MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

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

Line 1201: l_from_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;

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

Line 1202: l_to_unit_of_measure MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE_TL%TYPE;

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

Line 1203: l_from_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

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

Line 1204: l_to_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE;

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

Line 1217: l_primary_uom MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE;

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

Line 1594: FROM MTL_UNITS_OF_MEASURE

1590: l_to_uom_code := l_secondary_uom_code ;
1591: BEGIN
1592: SELECT unit_of_measure_tl, uom_class
1593: INTO l_from_unit_of_measure, l_from_uom_class
1594: FROM MTL_UNITS_OF_MEASURE
1595: WHERE UOM_CODE = l_from_uom_Code;
1596: -- Spr_Debug('100: ');
1597:
1598: EXCEPTION

Line 1609: FROM MTL_UNITS_OF_MEASURE

1605: -- Spr_Debug('120: ');
1606: BEGIN
1607: SELECT unit_of_measure_tl, uom_class
1608: INTO l_to_unit_of_measure, l_to_uom_class
1609: FROM MTL_UNITS_OF_MEASURE
1610: WHERE UOM_CODE = l_to_uom_Code;
1611: -- Spr_Debug('130: ');
1612:
1613: EXCEPTION