DBA Data[Home] [Help]

APPS.EAM_WO_DEFAULT_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 346: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP

342: THEN
343: begin
344: SELECT description
345: INTO l_activity_description
346: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP
347: WHERE MSI.inventory_item_id = p_eam_wo_rec.asset_activity_id
348: AND MSI.organization_id = MP.ORGANIZATION_ID
349: AND MP.MAINT_ORGANIZATION_ID = p_eam_wo_rec.organization_id
350: AND rownum = 1;