APPS.EAM_OBJECTINSTANTIATION_PUB dependencies on CSI_ITEM_INSTANCES

Line 61: FROM csi_item_instances

57: Instantiation process will be taken care by IB api */
58: /*
59: BEGIN
60: SELECT instance_id INTO l_maintenance_object_id
61: FROM csi_item_instances
62: WHERE inventory_item_id = p_inventory_item_id
63: AND serial_number = p_serial_number;
64:
65: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

Line 217: from csi_item_instances cii

213: -- Check PM_INSTANTIATED flag in MSN, if flag is checked, do nothing and return SUCCESS
214:
215: select cii.instantiation_flag, cii.network_asset_flag
216: into l_eam_instantiation_flag, l_network_asset_flag
217: from csi_item_instances cii
218: where cii.instance_id = p_maintenance_object_id;
219:
220: begin
221: select eomd.accounting_class_code, eomd.owning_department_id

Line 223: FROM csi_item_instances cii, eam_org_maint_defaults eomd, mtl_parameters mp

219:
220: begin
221: select eomd.accounting_class_code, eomd.owning_department_id
222: INTO l_class_code, l_owning_department_id
223: FROM csi_item_instances cii, eam_org_maint_defaults eomd, mtl_parameters mp
224: WHERE cii.instance_id = p_maintenance_object_id
225: and eomd.object_type = 50
226: and eomd.object_id = cii.instance_id
227: and mp.organization_id = cii.last_vld_organization_id

Line 317: UPDATE csi_item_instances

313: RAISE FND_API.G_EXC_ERROR;
314: END IF;
315:
316: -- 6:Set PM_INSTANTIATED flag in MSN
317: UPDATE csi_item_instances
318: SET instantiation_flag = 'Y'
319: WHERE instance_id = p_maintenance_object_id;
320:
321: -- 7: Insert Log into EAM_ASSET_LOG for Activate Asset Event while Asset Creation

Line 326: FROM csi_item_instances cii, mtl_parameters mp

322: -- with Active Status and Operational Log Flag Checked.
323:
324: SELECT mp.maint_organization_id, cii.instance_number, cii.active_start_date, cii.operational_log_flag
325: INTO l_maint_orgid, l_reference, l_event_date, l_operational_log_flag
326: FROM csi_item_instances cii, mtl_parameters mp
327: WHERE cii.instance_id = p_maintenance_object_id
328: AND cii.last_vld_organization_id = mp.organization_id ;
329:
330: IF (l_operational_log_flag = 'Y' ) THEN