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 125: FROM mtl_lot_numbers

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

Line 1573: FROM mtl_lot_numbers

1569: WHERE organization_id = p_organization_id;
1570:
1571: CURSOR c_lot_exp IS
1572: SELECT expiration_date
1573: FROM mtl_lot_numbers
1574: WHERE inventory_item_id = p_inventory_item_id
1575: AND organization_id = p_organization_id
1576: AND lot_number = p_lot_number;
1577:

Line 4403: FROM mtl_lot_numbers

4399: WHERE organization_id = p_organization_id;
4400:
4401: CURSOR c_lot_exp IS
4402: SELECT expiration_date
4403: FROM mtl_lot_numbers
4404: WHERE inventory_item_id = p_inventory_item_id
4405: AND organization_id = p_organization_id
4406: AND lot_number = p_lot_number;
4407: