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.CSD_BULK_RECEIVE_UTIL dependencies on MTL_SERIAL_NUMBERS

Line 519: from mtl_serial_numbers

515: -- Cursor to verify the Serial number against the Item
516: Cursor c_validate_sn_item (p_inventory_item_id in Number,p_serial_number in Varchar2) is
517: Select
518: inventory_item_id
519: from mtl_serial_numbers
520: where serial_number = p_serial_number
521: and inventory_item_id = p_inventory_item_id;
522:
523: -- Local variables

Line 978: from mtl_serial_numbers

974: -- Cursor to get Item Revision
975: Cursor c_get_item_revision ( p_inventory_item_id in Number,p_serial_number in Varchar2) is
976: Select
977: revision
978: from mtl_serial_numbers
979: where serial_number = p_serial_number
980: and inventory_item_id = p_inventory_item_id;
981:
982: -- Cursor to get Party site use id