DBA Data[Home] [Help]

APPS.AHL_OSP_ORDERS_PVT dependencies on MTL_SERIAL_NUMBERS

Line 5349: FROM mtl_serial_numbers

5345: WHERE organization_id = c_organization_id
5346: AND secondary_inventory_name = c_sub_inventory;
5347: CURSOR check_serial_number (c_inv_item_id NUMBER, c_serial_number VARCHAR2) IS
5348: SELECT 'X'
5349: FROM mtl_serial_numbers
5350: WHERE inventory_item_id = c_inv_item_id
5351: AND serial_number = c_serial_number;
5352: CURSOR check_lot_number (c_inv_item_id NUMBER, c_org_id NUMBER, c_lot_number VARCHAR2) IS
5353: SELECT 'X'