APPS.EAM_COMPLETION dependencies on EAM_WORK_ORDER_DETAILS

Line 1055: from wip_discrete_jobs wdj,eam_work_order_details ewod,wip_entities we

1051: l_old_system_status,
1052: l_old_eam_status,
1053: l_workflow_type,
1054: l_wip_entity_name
1055: from wip_discrete_jobs wdj,eam_work_order_details ewod,wip_entities we
1056: where wdj.wip_entity_id = x_wip_entity_id
1057: AND wdj.wip_entity_id = ewod.wip_entity_id(+)
1058: AND wdj.wip_entity_id = we.wip_entity_id;
1059:

Line 1226: UPDATE EAM_WORK_ORDER_DETAILS

1222: x_workflow_process => l_workflow_process
1223: );
1224:
1225: IF(l_approval_required) THEN
1226: UPDATE EAM_WORK_ORDER_DETAILS
1227: SET user_defined_status_id=3,
1228: pending_flag='Y',
1229: last_update_date=SYSDATE,
1230: last_update_login=FND_GLOBAL.login_id,

Line 1761: --Update Eam_Work_Order_Details with user_defined_status_id

1757: where wip_entity_id = x_wip_entity_id and
1758: organization_id = i_org_id;
1759:
1760:
1761: --Update Eam_Work_Order_Details with user_defined_status_id
1762: UPDATE EAM_WORK_ORDER_DETAILS
1763: SET last_update_date = sysdate,
1764: last_updated_by = x_user_id,
1765: last_update_login = x_user_id,

Line 1762: UPDATE EAM_WORK_ORDER_DETAILS

1758: organization_id = i_org_id;
1759:
1760:
1761: --Update Eam_Work_Order_Details with user_defined_status_id
1762: UPDATE EAM_WORK_ORDER_DETAILS
1763: SET last_update_date = sysdate,
1764: last_updated_by = x_user_id,
1765: last_update_login = x_user_id,
1766: user_defined_status_id=i_status_type