DBA Data[Home] [Help]

APPS.EAM_JOBCLOSE_PRIV dependencies on WIP_ENTITIES

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