DBA Data[Home] [Help]

APPS.EAM_REBUILD dependencies on CSI_ITEM_INSTANCES

Line 210: from csi_item_instances cii, mtl_parameters mp

206: --find maintenance object type,id,source
207: if (l_rebuild_item_id is not null and l_rebuild_serial_number is not null) then
208: BEGIN
209: select cii.instance_id into l_maintenance_object_id
210: from csi_item_instances cii, mtl_parameters mp
211: where cii.inventory_item_id = l_rebuild_item_id and cii.serial_number = l_rebuild_serial_number
212: and mp.organization_id = cii.last_vld_organization_id
213: and mp.maint_organization_id =l_org_id;
214: