DBA Data[Home] [Help]

APPS.EAM_UTILITY_GRP dependencies on WIP_DISCRETE_JOBS

Line 77: from WIP_DISCRETE_JOBS wdj

73:
74: CURSOR c_rebuilds IS
75:
76: select wdj.maintenance_object_id
77: from WIP_DISCRETE_JOBS wdj
78: where wdj.parent_wip_entity_id = p_wip_entity_id
79: and wdj.organization_id = p_organization_id
80: and wdj.manual_rebuild_flag = 'N'
81: and wdj.maintenance_object_type = 3;

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