APPS.EAM_METERREADING_UTILITY_PVT dependencies on WIP_DISCRETE_JOBS

Line 284: FROM wip_discrete_jobs wdj

280:
281: /* Bug # 5255459 : Disable meter hiearchy for instances which are already removed */
282: CURSOR cur_replaced_instance IS
283: SELECT wdj.maintenance_object_id instance_id
284: FROM wip_discrete_jobs wdj
285: WHERE wdj.maintenance_object_type = 3 AND wdj.manual_rebuild_flag = 'N'
286: AND wdj.parent_wip_entity_id = p_wip_entity_id;
287:
288: BEGIN

Line 313: FROM wip_discrete_jobs wdj

309:
310: l_counter_tbl.delete;
311:
312: SELECT maintenance_object_id into l_instance_id
313: FROM wip_discrete_jobs wdj
314: WHERE wip_entity_id = l_eam_wo_comp_rebuild_tbl(ii).wip_entity_id;
315:
316: SELECT cca.counter_id
317: BULK COLLECT INTO l_counter_tbl

Line 431: FROM wip_discrete_jobs

427: IF p_eam_wo_comp_rebuild_tbl(ii).ACTIVITY_ID IS NOT NULL THEN
428:
429: SELECT REQUESTED_START_DATE,due_date,primary_item_id
430: INTO l_scheduled_start_date,l_scheduled_completion_date,l_primary_item_id
431: FROM wip_discrete_jobs
432: WHERE wip_entity_id = p_eam_wo_comp_rebuild_tbl(ii).rebuild_wip_entity_id
433: AND organization_id = p_eam_wo_comp_rebuild_tbl(ii).organization_id;
434:
435: IF l_primary_item_id IS NULL THEN

Line 654: UPDATE wip_discrete_jobs

650: x_eam_wo_comp_rebuild_tbl := p_eam_wo_comp_rebuild_tbl;
651:
652: FOR I IN p_eam_wo_comp_rebuild_tbl.FIRST..p_eam_wo_comp_rebuild_tbl.LAST LOOP
653:
654: UPDATE wip_discrete_jobs
655: SET maintenance_object_type = 3 ,
656: maintenance_object_id = p_eam_wo_comp_rebuild_tbl(i).instance_id_removed,
657: rebuild_serial_number = ( select serial_number
658: from csi_item_instances