APPS.EAM_REBUILDS_PVT dependencies on CSI_ITEM_INSTANCES

Line 136: from wip_discrete_jobs wdj, mtl_serial_numbers msn, csi_item_instances cii

132: if (p_validate_mode <> VALIDATE_ISSUE) then
133:
134:
135: select msn.gen_object_id into l_parent_object_id
136: from wip_discrete_jobs wdj, mtl_serial_numbers msn, csi_item_instances cii
137: where wdj.wip_entity_id = p_wip_entity_id
138: and wdj.maintenance_object_id = cii.instance_id
139: and wdj.maintenance_object_type = 3
140: and cii.serial_number = msn.serial_number

Line 208: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd, csi_item_instances cii

204: end if;
205: if (l_serial_control_code > 1) then
206:
207: select meaa.activity_association_id into l_dummy_num
208: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd, csi_item_instances cii
209: where ( meaa.end_date_active is null or meaa.end_date_active > sysdate)
210: and (meaa.start_date_active is null or meaa.start_date_active < sysdate)
211: and meaa.asset_activity_id = p_rebuild_activity_id
212: and nvl(meaa.tmpl_flag, 'N') = 'N'