APPS.WIP_EAM_UTILS dependencies on WIP_DISCRETE_JOBS

Line 208: wip_discrete_jobs where

204:
205: -- Case 3. Rebuild WO with a parent.
206: if l_parent_weid is not null then
207: select class_code into x_class_code from
208: wip_discrete_jobs where
209: wip_entity_id = l_parent_weid
210: and organization_id = p_org_id;
211: return;
212:

Line 463: wip_discrete_jobs where

459:
460: -- Case 3. Rebuild WO with a parent.
461: if l_parent_weid is not null then
462: select class_code into x_class_code from
463: wip_discrete_jobs where
464: wip_entity_id = l_parent_weid
465: and organization_id = p_org_id;
466: return;
467:

Line 603: from wip_discrete_jobs

599: begin
600:
601: select nvl(asset_number,rebuild_serial_number), nvl(asset_group_id,rebuild_item_id)
602: into l_asset_number, l_inv_item_id
603: from wip_discrete_jobs
604: where wip_entity_id = p_wip_entity_id
605: and organization_id = p_organization_id;
606:
607:

Line 819: from wip_discrete_jobs

815: owning_department
816: into l_start_date,
817: l_completion_date,
818: l_owning_department_id
819: from wip_discrete_jobs
820: where wip_entity_id = l_wip_entity_id
821: and organization_id = l_organization_id;
822:
823: if (l_owning_department_id is null) then

Line 827: from wip_discrete_jobs wdj,mtl_serial_numbers msn

823: if (l_owning_department_id is null) then
824: /* Changes for IB convergence */
825: /* select distinct msn.owning_department_id
826: into l_owning_department_id
827: from wip_discrete_jobs wdj,mtl_serial_numbers msn
828: where wdj.asset_group_id = msn.inventory_item_id (+)
829: and wdj.organization_id = msn.current_organization_id (+)
830: and wdj.asset_number = msn.serial_number (+)
831: and wdj.wip_entity_id = l_wip_entity_id

Line 836: from eam_org_maint_defaults eomd, wip_discrete_jobs wdj

832: and wdj.organization_id = l_organization_id;*/
833:
834: select eomd.owning_department_id
835: into l_owning_department_id
836: from eam_org_maint_defaults eomd, wip_discrete_jobs wdj
837: where wdj.maintenance_object_type = 3
838: and wdj.organization_id = eomd.organization_id (+)
839: and eomd.object_type (+) = 50
840: and eomd.object_id (+) = wdj.maintenance_object_id