DBA Data[Home] [Help]

APPS.EAM_REBUILD dependencies on MTL_SYSTEM_ITEMS

Line 116: mtl_system_items msi,

112: eomd.owning_department_id,
113: eomd.tagging_required_flag,
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

Line 223: FROM mtl_system_items msi, mtl_parameters mp

219: END;
220: else
221: BEGIN
222: SELECT msi.inventory_item_id into l_maintenance_object_id
223: FROM mtl_system_items msi, mtl_parameters mp
224: WHERE msi.inventory_item_id = l_rebuild_item_id
225: and mp.organization_id = msi.organization_id
226: and mp.maint_organization_id =l_org_id
227: and rownum = 1;