APPS.WIP_EAM_UTILS dependencies on MTL_EAM_ASSET_ACTIVITIES

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 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 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 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'