DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on MTL_EAM_ASSET_NUMBERS_V

Line 229: FROM mtl_eam_asset_numbers_v meanv

225:
226: -- Added for NF2008 - Copy Asset Number to Notes to Approver on Purchase Requisitions
227: SELECT meanv.descriptive_text, meanv.asset_criticality,instance_number
228: INTO l_descriptive_text, l_asset_criticality,l_asset_number
229: FROM mtl_eam_asset_numbers_v meanv
230: WHERE meanv.serial_number = l_serial_number
231: AND meanv.inventory_item_id = l_asset_group_id
232: AND meanv.CURRENT_ORGANIZATION_ID = nvl(l_asset_cur_org_id, l_organization_id);
233: --changed for the 14101354