DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on MTL_LOT_NUMBERS

Line 5004: FROM mtl_lot_numbers

5000: WHERE inventory_item_id = c_inv_item_id
5001: AND serial_number = c_serial_number;
5002: CURSOR check_lot_number (c_inv_item_id NUMBER, c_org_id NUMBER, c_lot_number VARCHAR2) IS
5003: SELECT 'X'
5004: FROM mtl_lot_numbers
5005: WHERE inventory_item_id = c_inv_item_id
5006: AND organization_id = c_org_id
5007: AND lot_number = c_lot_number;
5008: