APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on CSI_ITEM_INSTANCES

Line 95: from csi_item_instances where instance_id = l_maintenance_object_id;

91: if p_maintenance_object_id is not null then
92: l_maintenance_object_id := p_maintenance_object_id;
93:
94: select instance_number, inventory_item_id into l_instance_number, l_asset_group_id
95: from csi_item_instances where instance_id = l_maintenance_object_id;
96: else
97: if (p_asset_number is not null and p_asset_group is not null) then
98: select instance_number, instance_id into l_instance_number, l_maintenance_object_id
99: from csi_item_instances where serial_number = p_asset_number

Line 99: from csi_item_instances where serial_number = p_asset_number

95: from csi_item_instances where instance_id = l_maintenance_object_id;
96: else
97: if (p_asset_number is not null and p_asset_group is not null) then
98: select instance_number, instance_id into l_instance_number, l_maintenance_object_id
99: from csi_item_instances where serial_number = p_asset_number
100: and inventory_item_id = p_asset_group;
101: l_asset_group_id := p_asset_group;
102: else
103: l_instance_number:=null;

Line 161: from csi_item_instances cii

157: l_stmt_number := 30 ;
158: begin
159: select cii.instance_description
160: into l_asset_description
161: from csi_item_instances cii
162: where cii.instance_id = l_maintenance_object_id;
163:
164: exception
165: when No_Data_Found then