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_MATERIAL_STATUS_GRP dependencies on MTL_LOT_NUMBERS

Line 1691: from mtl_lot_numbers

1687: --END IF;
1688:
1689: select status_id
1690: INTO g_isa_lot_number_status_id
1691: from mtl_lot_numbers
1692: where inventory_item_id = p_inventory_item_id
1693: and organization_id = p_organization_id
1694: and lot_number = p_lot_number;
1695: exception

Line 3046: FROM mtl_lot_numbers

3042: IF l_serial_control_code_destin IN (1,6) THEN
3043: BEGIN
3044: SELECT status_id
3045: INTO l_lot_status_id
3046: FROM mtl_lot_numbers
3047: WHERE organization_id = l_org_id
3048: AND inventory_item_id = p_inventory_item_id
3049: AND lot_number = p_lot_number;
3050: EXCEPTION

Line 3103: FROM mtl_lot_numbers

3099:
3100: BEGIN
3101: SELECT status_id, grade_code
3102: INTO l_lot_status_id, l_grade_code
3103: FROM mtl_lot_numbers
3104: WHERE organization_id = l_transfer_org_id
3105: AND inventory_item_id = p_inventory_item_id
3106: AND lot_number = p_lot_number;
3107: EXCEPTION