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 1451: from mtl_lot_numbers

1447: -- then retrieve status_id from MOQD.
1448: if (l_default_status_id is null) then
1449: select status_id
1450: INTO g_isa_lot_number_status_id
1451: from mtl_lot_numbers
1452: where inventory_item_id = p_inventory_item_id
1453: and organization_id = p_organization_id
1454: and lot_number = p_lot_number;
1455:

Line 2525: FROM mtl_lot_numbers

2521: IF l_serial_control_code_destin IN (1,6) THEN
2522: BEGIN
2523: SELECT status_id
2524: INTO l_lot_status_id
2525: FROM mtl_lot_numbers
2526: WHERE organization_id = l_org_id
2527: AND inventory_item_id = p_inventory_item_id
2528: AND lot_number = p_lot_number;
2529: EXCEPTION

Line 2582: FROM mtl_lot_numbers

2578:
2579: BEGIN
2580: SELECT status_id, grade_code
2581: INTO l_lot_status_id, l_grade_code
2582: FROM mtl_lot_numbers
2583: WHERE organization_id = l_transfer_org_id
2584: AND inventory_item_id = p_inventory_item_id
2585: AND lot_number = p_lot_number;
2586: EXCEPTION