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 1837: l_table_name := 'MTL_LOT_NUMBERS';

1833: trace('In get_lot_ser_default_attribute ');
1834: trace(' p_inventory_item_id='||p_inventory_item_id||',p_lot_serial='||p_lot_serial||',p_lot_or_serial='||p_lot_or_serial);
1835: END IF;
1836: IF p_lot_or_serial = 'LOT' THEN
1837: l_table_name := 'MTL_LOT_NUMBERS';
1838: l_flex_name := 'Lot Attributes';
1839: l_context_column := 'LOT_ATTRIBUTE_CATEGORY';
1840: ELSIF p_lot_or_serial = 'SERIAL' THEN
1841: l_table_name := 'MTL_SERIAL_NUMBERS';

Line 3588: FROM mtl_lot_numbers

3584: -- Get default attribute if it is a new lot
3585: l_new_lot := 0;
3586: BEGIN
3587: SELECT 1 INTO l_new_lot
3588: FROM mtl_lot_numbers
3589: WHERE organization_id = p_organization_id
3590: AND inventory_item_id = p_inventory_item_id
3591: AND lot_number = p_lot_number;
3592: EXCEPTION