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.

[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on CSI_ITEM_INSTANCES

Line 152: -- then find serial number, inventory_item_id in csi_item_instances table with wip_discrete_jobs.maintenance_object_id for serialized item

148:
149: if((p_wip_entity_id is not null) and (p_organization_id is not null)) then
150:
151: --bug# 8363544, using wip_discrete_jobs.maintenance_object_id instead of wip_discrete_jobs.asset_number which is no more used after R12
152: -- then find serial number, inventory_item_id in csi_item_instances table with wip_discrete_jobs.maintenance_object_id for serialized item
153: -- there is no asset number for non-serialized item
154: -- Use wdj.rebuild_item_id as group id for non-serialized items; otherwise, find group id in table "csi_item_instances" as well.
155: SELECT wdj.project_id, wdj.task_id, we.wip_entity_name, wdj.maintenance_object_id,
156: wdj.maintenance_object_type, wdj.organization_id, wdj.priority

Line 154: -- Use wdj.rebuild_item_id as group id for non-serialized items; otherwise, find group id in table "csi_item_instances" as well.

150:
151: --bug# 8363544, using wip_discrete_jobs.maintenance_object_id instead of wip_discrete_jobs.asset_number which is no more used after R12
152: -- then find serial number, inventory_item_id in csi_item_instances table with wip_discrete_jobs.maintenance_object_id for serialized item
153: -- there is no asset number for non-serialized item
154: -- Use wdj.rebuild_item_id as group id for non-serialized items; otherwise, find group id in table "csi_item_instances" as well.
155: SELECT wdj.project_id, wdj.task_id, we.wip_entity_name, wdj.maintenance_object_id,
156: wdj.maintenance_object_type, wdj.organization_id, wdj.priority
157: INTO l_project_id,l_task_id, l_wip_entity_name, l_maintenance_object_id,
158: l_maintenance_object_type, l_organization_id, l_priority

Line 209: -- To get the correct asset number from csi_item_instances for serialized items

205: AND lookup_type='WIP_EAM_ACTIVITY_PRIORITY';
206: end if;
207:
208: -- Added for the bug 8363544, the fix of the previous bug fixing
209: -- To get the correct asset number from csi_item_instances for serialized items
210: IF l_maintenance_object_type = 3 THEN
211:
212: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
213: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Serialized Asset Retrieving info from csi_item_instances');

Line 213: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Serialized Asset Retrieving info from csi_item_instances');

209: -- To get the correct asset number from csi_item_instances for serialized items
210: IF l_maintenance_object_type = 3 THEN
211:
212: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
213: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Serialized Asset Retrieving info from csi_item_instances');
214: END IF;
215:
216: SELECT serial_number, inventory_item_id, last_vld_organization_id
217: INTO l_serial_number, l_asset_group_id, l_asset_cur_org_id

Line 218: FROM csi_item_instances

214: END IF;
215:
216: SELECT serial_number, inventory_item_id, last_vld_organization_id
217: INTO l_serial_number, l_asset_group_id, l_asset_cur_org_id
218: FROM csi_item_instances
219: WHERE instance_id =l_maintenance_object_id;
220: --changed for the 14101354..Retrieving New org Id if the asset is moved out of current org
221: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
222: EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_PROCESS_WO_UTIL_PVT.create_requisition : Checking query variables are null or not : Serial Number:'|| l_serial_number);