DBA Data[Home] [Help]

APPS.EAM_JOBCLOSE_PRIV dependencies on WIP_ENTITIES

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