APPS.EAM_REBUILD dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 37: from mtl_material_transactions_temp mmtt

33: into l_rebuildSerNum,
34: l_rebuildItemID,
35: l_orgID,
36: l_txnDate
37: from mtl_material_transactions_temp mmtt
38: where mmtt.transaction_temp_id = p_tempId;
39:
40: --call genealogy API whether or not a serial exists. The eam procedure
41: --will figure out what to do (if anything).

Line 115: FROM MTL_MATERIAL_TRANSACTIONS_TEMP mmtt,

111: to_number(meaa.priority_code) as priority_code,
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

Line 203: FROM MTL_MATERIAL_TRANSACTIONS_TEMP

199:
200: --fix for 3733049.Get the maintenance_object_id and type and then open the cursor
201: SELECT rebuild_item_id,rebuild_serial_number,organization_id
202: INTO l_rebuild_item_id,l_rebuild_serial_number,l_org_id
203: FROM MTL_MATERIAL_TRANSACTIONS_TEMP
204: where transaction_temp_id=p_tempId;
205:
206: --find maintenance object type,id,source
207: if (l_rebuild_item_id is not null and l_rebuild_serial_number is not null) then