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 2838: FROM mtl_serial_numbers msn

2834: -- Parent_asset_number
2835: BEGIN
2836: SELECT msn.gen_object_id
2837: INTO l_gen_object_id
2838: FROM mtl_serial_numbers msn
2839: ,csi_item_instances cii
2840: WHERE msn.inventory_item_id = cii.inventory_item_id
2841: AND msn.serial_number = cii.serial_number
2842: AND cii.instance_id = p_instance_header_tbl(tab_row).instance_id;

Line 2856: ,mtl_serial_numbers msn

2852: ,cii.instance_number
2853: INTO p_instance_header_tbl(tab_row).parent_asset_group
2854: ,p_instance_header_tbl(tab_row).parent_asset_number
2855: FROM mtl_system_items_b_kfv msi
2856: ,mtl_serial_numbers msn
2857: ,csi_item_instances cii
2858: ,mtl_object_genealogy mog
2859: WHERE msn.gen_object_id= mog.parent_object_id
2860: AND mog.object_id = l_gen_object_id