DBA Data[Home] [Help]

APPS.EAM_UTILITY_GRP dependencies on WIP_OPERATIONS

Line 237: from wip_discrete_jobs wdj, wip_entities we, csi_item_instances cii, wip_operations wo

233: if (p_gen_object_id is not null) then
234:
235: select min(wdj.scheduled_start_date) as NEXT_MAINT_DATE
236: into l_maint_date
237: from wip_discrete_jobs wdj, wip_entities we, csi_item_instances cii, wip_operations wo
238: where we.entity_type = 6
239: and wdj.wip_entity_id = we.wip_entity_id
240: and wdj.organization_id = we.organization_id
241: and wdj.maintenance_object_type = 3