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_ITEM_INSTANCE_PVT dependencies on MTL_SERIAL_NUMBERS

Line 2819: FROM mtl_serial_numbers msn

2815: -- Parent_asset_number
2816: BEGIN
2817: SELECT msn.gen_object_id
2818: INTO l_gen_object_id
2819: FROM mtl_serial_numbers msn
2820: ,csi_item_instances cii
2821: WHERE msn.inventory_item_id = cii.inventory_item_id
2822: AND msn.serial_number = cii.serial_number
2823: AND cii.instance_id = p_instance_header_tbl(tab_row).instance_id;

Line 2837: ,mtl_serial_numbers msn

2833: ,cii.instance_number
2834: INTO p_instance_header_tbl(tab_row).parent_asset_group
2835: ,p_instance_header_tbl(tab_row).parent_asset_number
2836: FROM mtl_system_items_b_kfv msi
2837: ,mtl_serial_numbers msn
2838: ,csi_item_instances cii
2839: ,mtl_object_genealogy mog
2840: WHERE msn.gen_object_id= mog.parent_object_id
2841: AND mog.object_id = l_gen_object_id