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

Line 128: FROM mtl_lot_numbers

124: x_Concatenated_Segments := NULL;
125:
126: IF x_Lot_Number IS NOT NULL THEN
127: SELECT expiration_date INTO x_Expiration_Date
128: FROM mtl_lot_numbers
129: WHERE lot_number = x_Lot_Number AND
130: inventory_item_id = p_Inventory_Item_Id AND
131: organization_id = p_Current_Organization_Id;
132: END IF;

Line 1420: FROM mtl_lot_numbers

1416: WHERE organization_id = p_organization_id;
1417:
1418: CURSOR c_lot_exp IS
1419: SELECT expiration_date
1420: FROM mtl_lot_numbers
1421: WHERE inventory_item_id = p_inventory_item_id
1422: AND organization_id = p_organization_id
1423: AND lot_number = p_lot_number;
1424:

Line 4124: FROM mtl_lot_numbers

4120: WHERE organization_id = p_organization_id;
4121:
4122: CURSOR c_lot_exp IS
4123: SELECT expiration_date
4124: FROM mtl_lot_numbers
4125: WHERE inventory_item_id = p_inventory_item_id
4126: AND organization_id = p_organization_id
4127: AND lot_number = p_lot_number;
4128: