DBA Data[Home] [Help]

APPS.EAM_JOBCLOSE_PRIV dependencies on EAM_WORK_ORDER_DETAILS

Line 190: FROM wip_discrete_jobs wdj, wip_dj_close_temp wdct,eam_work_order_details ewod,wip_entities we

186: CURSOR workorders
187: IS
188: SELECT wdj.wip_entity_id, we.wip_entity_name,
189: wdj.status_type,wdj.organization_id,ewod.user_defined_status_id,ewod.workflow_type
190: FROM wip_discrete_jobs wdj, wip_dj_close_temp wdct,eam_work_order_details ewod,wip_entities we
191: WHERE wdct.group_id = p_group_id
192: and wdct.wip_entity_id = wdj.wip_entity_id
193: and wdct.organization_id = wdj.organization_id
194: and wdj.wip_entity_id = ewod.wip_entity_id

Line 295: UPDATE EAM_WORK_ORDER_DETAILS

291: AND organization_id = l_workorder_tbl(i).organization_id;
292:
293: IF(l_new_status_type <> 14) THEN
294:
295: UPDATE EAM_WORK_ORDER_DETAILS
296: SET USER_DEFINED_STATUS_ID = l_new_status_type,
297: last_update_date = SYSDATE,
298: last_updated_by = FND_GLOBAL.user_id,
299: last_update_login = FND_GLOBAL.login_id