APPS.EAM_WO_UTILITY_PVT dependencies on EAM_WORK_ORDER_DETAILS

Line 240: FROM wip_discrete_jobs wdj, wip_entities we,eam_work_order_details ewod

236: , l_eam_wo_rec.pm_suggested_end_date
237: , l_eam_wo_rec.pm_base_meter_reading
238: , l_eam_wo_rec.pm_base_meter
239: , l_eam_wo_rec.failure_code_required
240: FROM wip_discrete_jobs wdj, wip_entities we,eam_work_order_details ewod
241: WHERE wdj.wip_entity_id = we.wip_entity_id
242: AND wdj.organization_id = we.organization_id
243: AND wdj.wip_entity_id = p_wip_entity_id
244: AND wdj.organization_id = p_organization_id

Line 523: INSERT INTO EAM_WORK_ORDER_DETAILS

519: , p_eam_wo_rec.description
520: , p_eam_wo_rec.asset_activity_id
521: , MTL_GEN_OBJECT_ID_S.nextval);
522:
523: INSERT INTO EAM_WORK_ORDER_DETAILS
524: (
525: wip_entity_id
526: , organization_id
527: , user_defined_status_id

Line 747: UPDATE EAM_WORK_ORDER_DETAILS

743: WHERE wip_entity_id = p_eam_wo_rec.wip_entity_id
744: AND organization_id = p_eam_wo_rec.organization_id;
745:
746:
747: UPDATE EAM_WORK_ORDER_DETAILS
748: SET wip_entity_id = p_eam_wo_rec.wip_entity_id
749: , organization_id = p_eam_wo_rec.organization_id
750: , user_defined_status_id = p_eam_wo_rec.user_defined_status_id
751: , pending_flag = p_eam_wo_rec.pending_flag