[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select wdj.maintenance_object_id
from WIP_DISCRETE_JOBS wdj
where wdj.parent_wip_entity_id = p_wip_entity_id
and wdj.organization_id = p_organization_id
and wdj.manual_rebuild_flag = 'N'
and wdj.maintenance_object_type = 3;
SELECT entity_type
INTO l_entity_type
FROM wip_entities we
WHERE we.wip_entity_id = p_wip_entity_id
and we.organization_id = p_organization_id;
select min(wdj.scheduled_start_date) as NEXT_MAINT_DATE
into l_maint_date
from wip_discrete_jobs wdj, wip_entities we, csi_item_instances cii, wip_operations wo
where we.entity_type = 6
and wdj.wip_entity_id = we.wip_entity_id
and wdj.organization_id = we.organization_id
and wdj.maintenance_object_type = 3
and wdj.maintenance_object_id = cii.instance_id
and wdj.organization_id = cii.last_vld_organization_id
and cii.equipment_gen_object_id = p_gen_object_id
and wdj.organization_id = wo.organization_id (+)
and wdj.wip_entity_id = wo.wip_entity_id (+)
and wdj.status_type in (1,3,17)
and (nvl(wdj.shutdown_type,1) > 1 OR nvl(wo.shutdown_type,1) > 1 )
and wdj.scheduled_start_date > sysdate;