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

Line 1680: mtl_serial_numbers msn

1676: CURSOR parent_srl_cur(p_gen_object_id in number) IS
1677: SELECT msn.serial_number,
1678: msn.inventory_item_id
1679: FROM mtl_object_genealogy mog,
1680: mtl_serial_numbers msn
1681: WHERE mog.object_type = 2 -- serial genealogy
1682: AND mog.object_id = p_gen_object_id
1683: AND mog.parent_object_type = 2 -- serial genealogy
1684: AND msn.gen_object_id = mog.parent_object_id

Line 1720: FROM mtl_serial_numbers

1716: gen_object_id
1717: INTO l_current_status,
1718: l_current_org_id,
1719: l_gen_object_id
1720: FROM mtl_serial_numbers
1721: WHERE serial_number = p_serial_number
1722: AND inventory_item_id = p_item_id;
1723:
1724: FOR parent_srl_rec IN parent_srl_cur(l_gen_object_id)