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 CSI_ITEM_INSTANCES

Line 13: ( select * from csi_item_instances

9:
10: select 'Y' into l_asset_exists
11: from dual
12: where exists
13: ( select * from csi_item_instances
14: where pn_location_id = p_location_id
15: and nvl(active_start_date, sysdate-1) < sysdate
16: and nvl(active_end_date, sysdate+1) > sysdate);
17:

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 119: (select * from csi_item_instances where

115:
116: begin
117: select 'Y' into l_parent_exists_in_eam from dual
118: where exists
119: (select * from csi_item_instances where
120: pn_location_id = p_parent_location_id);
121:
122: exception
123: when no_data_found then