DBA Data[Home] [Help]

APPS.EAM_WO_UTILITY_PVT dependencies on EAM_WORK_ORDER_DETAILS

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

238: , l_eam_wo_rec.pm_base_meter_reading
239: , l_eam_wo_rec.pm_base_meter
240: , l_eam_wo_rec.failure_code_required
241: , l_eam_wo_rec.planner_type --vardha
242: FROM wip_discrete_jobs wdj, wip_entities we,eam_work_order_details ewod
243: WHERE wdj.wip_entity_id = we.wip_entity_id
244: AND wdj.organization_id = we.organization_id
245: AND wdj.wip_entity_id = p_wip_entity_id
246: AND wdj.organization_id = p_organization_id

Line 525: INSERT INTO EAM_WORK_ORDER_DETAILS

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

Line 751: UPDATE EAM_WORK_ORDER_DETAILS

747: WHERE wip_entity_id = p_eam_wo_rec.wip_entity_id
748: AND organization_id = p_eam_wo_rec.organization_id;
749:
750:
751: UPDATE EAM_WORK_ORDER_DETAILS
752: SET wip_entity_id = p_eam_wo_rec.wip_entity_id
753: , organization_id = p_eam_wo_rec.organization_id
754: , user_defined_status_id = p_eam_wo_rec.user_defined_status_id
755: , pending_flag = p_eam_wo_rec.pending_flag