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

Line 100: FROM mtl_serial_numbers msn, csi_item_instances cii

96: begin
97: -- Bug # 3372982
98: SELECT cii.active_start_date, cii.active_end_date, msn.gen_object_id, cii.instance_id
99: INTO l_start_date, l_end_date, l_gen_object_id, l_instance_id
100: FROM mtl_serial_numbers msn, csi_item_instances cii
101: WHERE cii.pn_location_id = p_pn_location_id
102: and msn.current_organization_id = cii.last_vld_organization_id
103: and msn.inventory_item_id = cii.inventory_item_id
104: and msn.serial_number = cii.serial_number;

Line 160: FROM mtl_object_genealogy mog, mtl_serial_numbers msn

156:
157: -- Bug # 3372982
158: SELECT COUNT(*)
159: INTO l_parent_exists_in_mog
160: FROM mtl_object_genealogy mog, mtl_serial_numbers msn
161: WHERE mog.object_id = l_gen_object_id
162: AND msn.gen_object_id = mog.parent_object_id
163: AND mog.genealogy_type = 5
164: AND mog.start_date_active = l_pn_start_date