APPS.WIP_EAM_UTILS dependencies on EAM_ORG_MAINT_DEFAULTS

Line 156: into l_count from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

152: -- Case 2.1 From asset activity association
153: if p_asset_activity is not null then
154:
155: select count(*)
156: into l_count from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
157: where meaa.asset_activity_id = l_asset_activity_id
158: and meaa.maintenance_object_type = 3
159: and meaa.maintenance_object_id = l_instance_id
160: and eomd.organization_id = p_org_id

Line 167: select accounting_class_code into x_class_code from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

163: and eomd.accounting_class_code is not null
164: and nvl(meaa.tmpl_flag, 'N') = 'N';
165:
166: if l_count = 1 then
167: select accounting_class_code into x_class_code from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
168: where meaa.asset_activity_id = l_asset_activity_id
169: and meaa.maintenance_object_type = 3
170: and meaa.maintenance_object_id = l_instance_id
171: and eomd.organization_id = p_org_id

Line 183: from eam_org_maint_defaults eomd

179: -- 2.2 From asset definition
180:
181: select count(*)
182: into l_count
183: from eam_org_maint_defaults eomd
184: where eomd.organization_id = p_org_id
185: and eomd.object_type = 50
186: and eomd.object_id = l_instance_id
187: and eomd.accounting_class_code is not null;

Line 189: select accounting_class_code into x_class_code from eam_org_maint_defaults eomd

185: and eomd.object_type = 50
186: and eomd.object_id = l_instance_id
187: and eomd.accounting_class_code is not null;
188: if l_count = 1 then
189: select accounting_class_code into x_class_code from eam_org_maint_defaults eomd
190: where eomd.organization_id = p_org_id
191: and eomd.object_type = 50
192: and eomd.object_id = l_instance_id;
193: return;

Line 237: into l_count from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

233: -- 5.1 Default from Rebuild Activity combination
234:
235:
236: select count(*)
237: into l_count from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
238: where meaa.asset_activity_id = l_asset_activity_id
239: and meaa.maintenance_object_type = l_maintenance_object_type
240: and meaa.maintenance_object_id = l_instance_id
241: and eomd.organization_id = p_org_id

Line 249: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

245: and eomd.accounting_class_code is not null;
246:
247: if l_count = 1 then
248: select accounting_class_code into x_class_code
249: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
250: where meaa.asset_activity_id = l_asset_activity_id
251: and meaa.maintenance_object_type = l_maintenance_object_type
252: and meaa.maintenance_object_id = l_instance_id
253: and eomd.organization_id = p_org_id

Line 268: from eam_org_maint_defaults eomd

264: if p_serial_number is not null then
265:
266: select count(*)
267: into l_count
268: from eam_org_maint_defaults eomd
269: where eomd.organization_id = p_org_id
270: and eomd.object_type = 50
271: and eomd.object_id = l_instance_id
272: and eomd.accounting_class_code is not null;

Line 275: select accounting_class_code into x_class_code from eam_org_maint_defaults eomd

271: and eomd.object_id = l_instance_id
272: and eomd.accounting_class_code is not null;
273:
274: if l_count = 1 then
275: select accounting_class_code into x_class_code from eam_org_maint_defaults eomd
276: where eomd.organization_id = p_org_id
277: and eomd.object_type = 50
278: and eomd.object_id = l_instance_id;
279: return;

Line 409: into l_count from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

405: if p_asset_activity_id is not null then
406:
407:
408: select count(*)
409: into l_count from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
410: where meaa.asset_activity_id = l_asset_activity_id
411: and meaa.maintenance_object_type = 3
412: and meaa.maintenance_object_id = l_instance_id
413: and nvl(meaa.tmpl_flag, 'N') = 'N'

Line 421: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

417: and eomd.accounting_class_code is not null ;
418:
419: if l_count = 1 then
420: select accounting_class_code into x_class_code
421: from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
422: where meaa.asset_activity_id = l_asset_activity_id
423: and meaa.maintenance_object_type = 3
424: and meaa.maintenance_object_id = l_instance_id
425: and nvl(meaa.tmpl_flag, 'N') = 'N'

Line 437: from eam_org_maint_defaults eomd

433: -- 2.2 From asset definition
434:
435: select count(*)
436: into l_count
437: from eam_org_maint_defaults eomd
438: where eomd.organization_id = p_org_id
439: and eomd.object_type = 50
440: and eomd.object_id = l_instance_id
441: and eomd.accounting_class_code is not null;

Line 444: select accounting_class_code into x_class_code from eam_org_maint_defaults eomd

440: and eomd.object_id = l_instance_id
441: and eomd.accounting_class_code is not null;
442:
443: if l_count = 1 then
444: select accounting_class_code into x_class_code from eam_org_maint_defaults eomd
445: where eomd.organization_id = p_org_id
446: and eomd.object_type = 50
447: and eomd.object_id = l_instance_id;
448: return;

Line 493: into l_count from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

489:
490:
491:
492: select count(*)
493: into l_count from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
494: where meaa.asset_activity_id = l_asset_activity_id
495: and meaa.maintenance_object_type = l_maintenance_object_type
496: and meaa.maintenance_object_id = l_instance_id
497: and eomd.organization_id = p_org_id

Line 504: select accounting_class_code into x_class_code from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd

500: and nvl(meaa.tmpl_flag, 'N') = 'N'
501: and eomd.accounting_class_code is not null ;
502:
503: if l_count = 1 then
504: select accounting_class_code into x_class_code from mtl_eam_asset_activities meaa, eam_org_maint_defaults eomd
505: where meaa.asset_activity_id = l_asset_activity_id
506: and meaa.maintenance_object_type = l_maintenance_object_type
507: and meaa.maintenance_object_id = l_instance_id
508: and nvl(meaa.tmpl_flag, 'N') = 'N'

Line 522: from eam_org_maint_defaults eomd

518: if p_serial_number is not null then
519:
520: select count(*)
521: into l_count
522: from eam_org_maint_defaults eomd
523: where eomd.organization_id = p_org_id
524: and eomd.object_type = 50
525: and eomd.object_id = l_instance_id
526: and eomd.accounting_class_code is not null;

Line 528: select accounting_class_code into x_class_code from eam_org_maint_defaults eomd

524: and eomd.object_type = 50
525: and eomd.object_id = l_instance_id
526: and eomd.accounting_class_code is not null;
527: if l_count = 1 then
528: select accounting_class_code into x_class_code from eam_org_maint_defaults eomd
529: where eomd.organization_id = p_org_id
530: and eomd.object_type = 50
531: and eomd.object_id = l_instance_id;
532: return;

Line 849: from eam_org_maint_defaults eomd, wip_discrete_jobs wdj

845: and wdj.organization_id = l_organization_id;*/
846:
847: select eomd.owning_department_id
848: into l_owning_department_id
849: from eam_org_maint_defaults eomd, wip_discrete_jobs wdj
850: where wdj.maintenance_object_type = 3
851: and wdj.organization_id = eomd.organization_id (+)
852: and eomd.object_type (+) = 50
853: and eomd.object_id (+) = wdj.maintenance_object_id