38: -- Cursor to verify the Serial number against the Item
39: Cursor c_validate_sn_item (p_inventory_item_id in Number,p_serial_number in Varchar2) is
40: Select
41: inventory_item_id
42: from mtl_serial_numbers
43: where serial_number = p_serial_number
44: and inventory_item_id = p_inventory_item_id;
45:
46: -- Local variables
451: -- Cursor to get Item Revision
452: Cursor c_get_item_revision ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
453: Select
454: revision
455: from mtl_serial_numbers
456: where serial_number = p_serial_number
457: and inventory_item_id = p_inventory_item_id;
458:
459: -- Cursor to get Party site use id