APPS.EAM_METERS_UTIL dependencies on WIP_DISCRETE_JOBS

Line 26: from mtl_eam_asset_activities meaa, wip_discrete_jobs wdj

22: x_activity_assoc_id number;
23: begin
24:
25: select activity_association_id into x_activity_assoc_id
26: from mtl_eam_asset_activities meaa, wip_discrete_jobs wdj
27: where meaa.asset_activity_id = wdj.primary_item_id
28: and meaa.maintenance_object_id = wdj.maintenance_object_id
29: and meaa.maintenance_object_type = wdj.maintenance_object_type
30: and wdj.wip_entity_id = p_wip_entity_id;

Line 169: from wip_discrete_jobs

165:
166: begin
167:
168: select maintenance_object_id into x_maintenance_object_id
169: from wip_discrete_jobs
170: where wip_entity_id = p_wip_entity_id;
171:
172: for a_meter in meters_csr(x_maintenance_object_id) LOOP
173: if (is_meter_reading_mandatory(p_wip_entity_id,

Line 503: FROM WIP_DISCRETE_JOBS wdj,EAM_WORK_ORDER_DETAILS ewod

499: --check if workorder is pm suggested workorder or not
500: BEGIN
501: SELECT wdj.pm_schedule_id,ewod.cycle_id,ewod.seq_id
502: INTO l_pm_schedule_id,l_cycle_id,l_seq_id
503: FROM WIP_DISCRETE_JOBS wdj,EAM_WORK_ORDER_DETAILS ewod
504: WHERE wdj.wip_entity_id = p_wip_entity_id and
505: ewod.wip_entity_id = wdj.wip_entity_id ;
506:
507: if ( l_pm_schedule_id is not null) then

Line 622: FROM WIP_DISCRETE_JOBS wdj,EAM_WORK_ORDER_DETAILS ewod

618: --check if workorder is pm suggested workorder or not
619: BEGIN
620: SELECT wdj.pm_schedule_id,ewod.cycle_id,ewod.seq_id
621: INTO l_pm_schedule_id,l_cycle_id,l_seq_id
622: FROM WIP_DISCRETE_JOBS wdj,EAM_WORK_ORDER_DETAILS ewod
623: WHERE wdj.wip_entity_id = p_wip_entity_id and
624: ewod.wip_entity_id = wdj.wip_entity_id ;
625:
626: if(l_pm_schedule_id is not null) then

Line 745: from wip_discrete_jobs wdj

741: ,wdj.scheduled_completion_date
742: into
743: l_sch_start_date
744: ,l_sch_end_date
745: from wip_discrete_jobs wdj
746: where wdj.wip_entity_id=p_wip_entity_id;
747:
748: -- backup last date to previous date
749: update mtl_eam_asset_activities

Line 781: from wip_discrete_jobs wdj, eam_work_order_details ewod

777: p_end_date, --added for bug #4096193
778: wdj.wip_entity_id,
779: ewod.pm_suggested_start_date,
780: ewod.pm_suggested_end_date
781: from wip_discrete_jobs wdj, eam_work_order_details ewod
782: where wdj.wip_entity_id=p_wip_entity_id
783: and wdj.wip_entity_id = ewod.wip_entity_id)
784: where meaa.activity_association_id = p_activity_assoc_id
785: and (( decode(l_schedule_option,3,last_scheduled_start_date,