[Home] [Help]
52: l_sr_interaction_id number;
53: l_workflow_process varchar2(30);
54: l_instance_id number;
55: l_instance_number varchar2(30);
56: l_instance_description csi_item_instances.instance_description%type;
57: l_maint_organization_id cs_incidents_all_b.maint_organization_id%type;
58: begin
59:
60: itemtype := 'EAMSRAPR';
97: -- if Asset Number is specified on Service Request
98: if (l_instance_id is not null) then
99: select instance_number,instance_description,concatenated_segments,msi.description
100: into l_instance_number,l_instance_description,l_concatenated_segments,l_conc_segments_description
101: from csi_item_instances cii, mtl_system_items_kfv msik, mtl_system_items msi
102: where cii.last_vld_organization_id = msi.organization_id
103: and cii.inventory_item_id = msi.inventory_item_id
104: and msi.organization_id = msik.organization_id
105: and msi.inventory_item_id = msik.inventory_item_id
333: l_prev_owner_id number;
334: End Commented for Bug 4488769*/
335: l_instance_id number;
336: l_instance_number varchar2(30);
337: l_instance_description csi_item_instances.instance_description%type;
338: l_maint_organization_id cs_incidents_all_b.maint_organization_id%type;
339:
340: begin
341: itemtype := 'EAMSRAPR';