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 504: FROM WIP_DISCRETE_JOBS wdj,EAM_WORK_ORDER_DETAILS ewod

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

Line 625: FROM WIP_DISCRETE_JOBS wdj,EAM_WORK_ORDER_DETAILS ewod

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

Line 748: from wip_discrete_jobs wdj

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

Line 784: from wip_discrete_jobs wdj, eam_work_order_details ewod

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