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.WMS_PACKING_WORKBENCH_PVT dependencies on MTL_LOT_NUMBERS

Line 1908: l_table_name := 'MTL_LOT_NUMBERS';

1904: trace('In get_lot_ser_default_attribute ');
1905: trace(' p_inventory_item_id='||p_inventory_item_id||',p_lot_serial='||p_lot_serial||',p_lot_or_serial='||p_lot_or_serial);
1906: END IF;
1907: IF p_lot_or_serial = 'LOT' THEN
1908: l_table_name := 'MTL_LOT_NUMBERS';
1909: l_flex_name := 'Lot Attributes';
1910: l_context_column := 'LOT_ATTRIBUTE_CATEGORY';
1911: ELSIF p_lot_or_serial = 'SERIAL' THEN
1912: l_table_name := 'MTL_SERIAL_NUMBERS';

Line 3754: FROM mtl_lot_numbers

3750: -- Get default attribute if it is a new lot
3751: l_new_lot := 0;
3752: BEGIN
3753: SELECT 1 INTO l_new_lot
3754: FROM mtl_lot_numbers
3755: WHERE organization_id = p_organization_id
3756: AND inventory_item_id = p_inventory_item_id
3757: AND lot_number = p_lot_number;
3758: EXCEPTION