APPS.EAM_WO_DEFAULT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 419: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP

415: THEN
416: begin
417: SELECT description
418: INTO l_activity_description
419: FROM MTL_SYSTEM_ITEMS_KFV MSI, MTL_PARAMETERS MP
420: WHERE MSI.inventory_item_id = p_eam_wo_rec.asset_activity_id
421: AND MSI.organization_id = MP.ORGANIZATION_ID
422: AND MP.MAINT_ORGANIZATION_ID = p_eam_wo_rec.organization_id
423: AND rownum = 1;

Line 1239: from csi_item_instances cii, mtl_system_items msi

1235: , msi.eam_item_type
1236: into l_serial_number
1237: , l_inventory_item_id
1238: , l_eam_item_type
1239: from csi_item_instances cii, mtl_system_items msi
1240: where cii.last_vld_organization_id = msi.organization_id
1241: and cii.inventory_item_id = msi.inventory_item_id
1242: and cii.instance_id = p_eam_wo_rec.maintenance_object_id;
1243:

Line 1254: from mtl_system_items msi, mtl_parameters mp

1250: elsif (p_eam_wo_rec.maintenance_object_type = 2) then
1251:
1252: select inventory_item_id
1253: into x_eam_wo_rec.rebuild_item_id
1254: from mtl_system_items msi, mtl_parameters mp
1255: where msi.organization_id = mp.organization_id
1256: and mp.maint_organization_id = p_eam_wo_rec.organization_id
1257: and msi.inventory_item_id = p_eam_wo_rec.maintenance_object_id
1258: and rownum = 1;