DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on MTL_SERIAL_NUMBERS

Line 42: from mtl_serial_numbers

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

Line 455: from mtl_serial_numbers

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