DBA Data[Home] [Help]

APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on MTL_EAM_ASSET_NUMBERS_V

Line 156: FROM mtl_eam_asset_numbers_v meanv

152: end if;
153: -- Added for NF2008 - Copy Asset Number to Notes to Approver on Purchase Requisitions
154: SELECT meanv.descriptive_text, meanv.asset_criticality,instance_number
155: INTO l_descriptive_text, l_asset_criticality,l_asset_number
156: FROM mtl_eam_asset_numbers_v meanv
157: WHERE meanv.serial_number = l_serial_number
158: AND meanv.inventory_item_id = l_asset_group_id
159: AND meanv.CURRENT_ORGANIZATION_ID = l_organization_id;
160: if l_project_id is not null then