APPS.EAM_METERS_UTIL dependencies on EAM_WORK_ORDER_DETAILS

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 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,