eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EAM_JOBCLOSE_PRIV dependencies on WIP_DISCRETE_JOBS

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 289: FROM WIP_DISCRETE_JOBS

285: /* FOR i IN l_workorder_tbl.FIRST..l_workorder_tbl.LAST LOOP
286: BEGIN
287: SELECT status_type
288: INTO l_new_status_type
289: FROM WIP_DISCRETE_JOBS
290: WHERE wip_entity_id = l_workorder_tbl(i).wip_entity_id
291: AND organization_id = l_workorder_tbl(i).organization_id;
292:
293: IF(l_new_status_type <> 14) THEN