APPS.EAM_REBUILD dependencies on EAM_ORG_MAINT_DEFAULTS
Line 118: (select * from eam_org_maint_defaults
114: to_number(eomd.shutdown_type_code) as shutdown_type_code
115: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,
116: mtl_system_items msi,
117: mtl_eam_asset_activities meaa, 118: (select * from eam_org_maint_defaults 119: where organization_id = l_org_id) eomd
120: --activity has to be assigned to the work order organization
121: -- hence no meed to join on MP.
122: WHERE transaction_temp_id = p_tempId