APPS.EAM_UTILITY_GRP dependencies on WIP_ENTITIES

Line 127: FROM wip_entities we

123: -------------------------------------------------------------------------
124:
125: SELECT entity_type
126: INTO l_entity_type
127: FROM wip_entities we
128: WHERE we.wip_entity_id = p_wip_entity_id
129: and we.organization_id = p_organization_id;
130:
131: IF (l_entity_type NOT IN (6,7)) THEN

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