DBA Data[Home] [Help]

APPS.EAM_JOBCLOSE_PRIV dependencies on WIP_DISCRETE_JOBS

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

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

Line 295: FROM WIP_DISCRETE_JOBS

291: /* FOR i IN l_workorder_tbl.FIRST..l_workorder_tbl.LAST LOOP
292: BEGIN
293: SELECT status_type
294: INTO l_new_status_type
295: FROM WIP_DISCRETE_JOBS
296: WHERE wip_entity_id = l_workorder_tbl(i).wip_entity_id
297: AND organization_id = l_workorder_tbl(i).organization_id;
298:
299: IF(l_new_status_type <> 14) THEN